Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “presort” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

237 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
presort9521954(None) 
presorts105311681presorts
resort65728621_resort
piefort1249532piefort
preform1439612preform
premolt11312072premolt
prescore124812372prescore
present94022732present
preset84430982pres_et
presift12312222presift
presoak1348452presoak
presold1059602presold
presong1039842presong
presorted1239452presorted
pressor93512882pressor_
pressors103212692pressors
prest75736352pres__t
prestore104217352prestore
pretor8315752pretor_
pretors9316812pretors
prework164210912prework
preworn124711222preworn
report85326022_report
resorb84914352_resorb
resorts74817192_resorts
retort66831152_retort
assort64916383_assort
besot76429713_beso_t
consort91319903consort
cresol8310213creso_l
cresols939653cresols
cresset93319943cresset
crest74632693cres__t
dehort104618103_dehort
deport94922393_deport
desert72725493_desert
desorb95210203_desorb
drest65530343dres__t
escort84616483__escort
eyesore1046173eyesore
freshet133416643freshet
missort9314653missort
passport1247593passport
peart76440753p_e_art
perform1439283perform
persalt9315413persalt
persist9315853persist
person83517873perso_n
persona92812453persona
persons93717013persons
pert66759323p_e__rt
pervert12315583pervert
peso66925823p_eso__
pesos77221623p_eso_s
pest65555293p_es__t
piedfort1444873piedfort
pieforts1344863pieforts
pierrot948833pierrot
pilewort1389133pilewort
plessor9317693plessor_
plessors10278253plessors
plexor1535253plexor_
plexors1645423plexors
port66059633p___ort
praetor938973praetor_
praetors1039833praetors
preabsorb1542853preabsorb
preact103220393pre_act
preadopt1348313preadopt
prearm104512353pre_arm
prebirth1543463prebirth
preboard1338263preboard
preboil1148953preboil
prebook1557523prebook
preboom1348253preboom
precast11314853precast
precent113520263precent
precept133112513precept
precode12311853precode
precook1577803precook
precool1139013precool
precoup1336123precoup
precure11312553precure
precut102016533pre_cut
predict12315323predict
predry1237873pre_dry
preedit10512463preedit
preempt1337723preempt
prefect141011073prefect
prefer113813203prefer_
prefers123713333prefers
prefire124012813prefire
preformat1646363preformat
preforms1537403preforms
preheat12413893preheat
preinsert1148573preinsert
prelect111013833prelect
preload1049813preload
prelusory1442873prelusory
premeet11615153premeet
premixt183510663premixt
premold1247863premold
premoral1249713premoral
premorse1237553premorse
prenoon9310043prenoon
preop94715873pre_o_p
preops104911943pre_ops
preoral9312673pre_oral
prepare111913623prepare
preriot9316413preriot
prerock1536723prerock
presa74319043pres__a
presage10312293presage
presale9416353presale
prescored14409403prescored
prescores133912173prescores
prescript1547033prescript
prese75228383pres__e
presell939303presell
presents103315643presents
preserve13108803preserve
presets94216423presets
preship1439793preship
preshow15237413preshow
preshown16255633preshown
preshows16267023preshows
preside10715613preside
presifts1366593presifts
presoaks1436603presoaks
presolve1347073presolve
presorting1339983presorting
presplit1247753presplit
press75425953pres__s
pressed103317313pressed
presser93717623presser
pressers103215023pressers
presses93523153presses
pressrun1045033pressrun
pressure1039773pressure
presswork1854533presswork
prester93519623prester
presters103419003presters
presto84216203pres_to
prestored125111673prestored
prestores114716083prestores
prestos93716083prestos
prests84021263pres_ts
presume11310303presume
preterit10315853preterit
preterm11310163preterm
pretest9517633pretest
pretext1639663pretext
pretold1049083pretold
prevent124016553prevent
preverb14317063preverb
previsor13116303previsor_
previsors14126483previsors
prewar114712583prewar_
prewarm14479613prewarm
prewarn124410153prewarn
prewire124311143prewire
preworks17599013preworks
preyer114413733preyer_
preyers124412363preyers
priest84125423pries__t
prior74316173pr_ior_
priors83914483pr_iors
priory114110263pr_iory
prisere9310943prisere
prison8514023priso_n
prisons9313223prisons
prosect11313393prosect
proser84223463proser_
prosers94219643prosers
prosit85124593pros_it
proso77222413proso__
prosody1336433prosody
prosoma11310223prosoma
prosos85718553proso_s
prost75434103pr__ost
provost1238573provost
prutot8311823pruto_t
purest84021933pures__t
purport1159393purport
reassort8410683_reassort
reboot84119333_reboot
rebore86625653_rebore
reborn810016963_reborn
recoat84024273_recoat
record96117433_record
recork126315493_recork
redout71820253_redout
reform11312713_reform
remora8414593_remora
reports94916213_reports
repot75132623_repo_t
resat55139683_res_at
rescore95616203_rescore
reseat64131493_reseat
resect84424703_resect
resent63833623_resent
reset55051863_res_et
reshoot102513893_reshoot
reshot93519633_reshot
resift94017723_resift
resist64524533_resist
resit54241043_res_it
resoak10311093_resoak
resod64720053_reso_d
resods74116303_resods
resojet14312823_resojet
resold73915363_resold
resole64624183_resole
resorbs95010523_resorbs
resorted9313493_resorted
resorter8312183_resorter
resow88217243_reso_w
resown94112923_resown
resows93915353_resows
respot83117633_respot
rest46459843_res__t
restart7320033_restart
restore75822983_restore
result6318223_result
retore67630773_retore
retorn610923433_retorn
retorts76016513_retorts
revert93529113_revert
revolt9316223_revolt
reword106321413_reword
rewore938030163_rewore
rework136619793_rework
reworn98122203_reworn
sort46264813___sort
tremor84210403tremor_
tremors93711233tremors
wrest84925433wres__t

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340272376.97019229.1
3Display Results2372370.0763118.4
 (SQL Overall)1786912377.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.