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 “presells” 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.

172 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
presells105828(None) 
presell939301presell_
pretells1047331pretells
resells73313201_resells
prebills1237292prebills
predella1145392predella
predellas1245282predellas
presales10315262presales
presents103315642presents
presets94216422prese_ts
pretell938242pretell_
reseals73917662_reseals
resell64215202_resell_
respells1056332_respells
retells73211522_retells
ainsells895403ainsells
bedells10379363_bedells
creels84416943cre_e_ls
crenelle1046333crenelle
crenelles1146733crenelles
crenels93711013crene_ls
cresols939653cres_ols
cresyls1234753cres_yls
crewels12438493crewe_ls
diesels8429143diese_ls
drywells1542113drywells
farewells1543073farewells
foretells1245633foretells
fresnels1135233fresnels
harebells1444193harebells
outsells888643outsells
oversells1236973oversells
pareses94718883parese__s
passels93913023passe_ls
peels75226423p_e_e_ls
persalts1038193persalts
perses85428063perse__s
pesetas938753p_esetas
pesewas1236223p_esewas
pestles93217693p_estles
prases84429023prase__s
prebends13347883prebends
prebill1138803prebill_
prebless1236823prebless
preboils1267293preboils
precedes13310713precedes
precents123015043precents
precepts14268893precepts
precess11310863prece_ss
prechills1645123prechills
precools1237703precools
predrills1244473predrills
preens85020113pre_e_ns
prees75937173pre_e__s
prefects1598133prefects
prefers123713333prefe_rs
prefiles133113443prefiles
preheats1339413preheats
prelects1299723prelects
premeal11310523premeal_
premeds12389593preme_ds
premolds1345843premolds
prepill1147583prepill_
prequels1934833prequels
presages11312203presages
presale9416353pres_ale
prese75228383prese___
preselect1346983preselect
preselects1464363preselects
preselling1338693preselling
presence122213513presence
presences132113793presences
present94022733prese_nt
presently1449063presently
preserve13108803preserve
preserves14109073preserves
preset84430983prese__t
presettle1145943presettle
presettles1245023presettles
preships1539313preships
preshows16267023preshows
presides11414913presides
presifts1366593presifts
presleep1244493presleep
presoaks1436603presoaks
presold1059603pres_old
presolve1347073presolve
presolves1456533presolves
presorts105311683presorts
presplit1247753presplit
press75425953pres___s
pressers103215023pressers
presses93523153pres_ses
pressors103212693pressors
presters103419003presters
prestos93716083pres_tos
prests84021263pres__ts
presumes1239843presumes
preteens1038123preteens
pretends11299113pretends
preterms1237223preterms
pretests10310013pretests
pretexts1735603pretexts
pretzels1934033pretzels
prevails1337663prevails
prevents133012293prevents
preverbs15295303preverbs
prexes154915953prexe__s
preyers124412363preye_rs
prezes173614693preze__s
prills84015613pr__ills
priseres10310823priseres
prises84133173prise__s
propels113412843prope_ls
prosects1239473prosects
prosers94219643prose_rs
proses84733473prose__s
prunella1044073prunella
prunellas1143683prunellas
prunelle1044983prunelle
prunelles1145063prunelles
prunello1043433prunello
prunellos1142893prunellos
rebels84518133_rebe_ls
rebills93510623_rebills
recalls92613623_recalls
reels55333263_re_e_ls
refalls103312243_refalls
refeels10379693_refeels
refell94214443_refell_
refels94618053_refe_ls
refills103711423_refills
reheels10298253_reheels
remelts93511493_remelts
repeals94014523_repeals
repels84318763_repe_ls
repolls939053_repolls
rerolls739943_rerolls
resails74616743_resails
resales74724903_resales
reseal64819643_reseal_
reseats74319583_reseats
reseaus74012153_reseaus
resects94115593_resects
resedas839123_resedas
reseeds84012333_reseeds
reseeks11348623_reseeks
resees63827483_rese_es
reseller83412223_reseller
resellers9299903_resellers
resends83513713_resends
resents74221223_resents
resets65427613_rese_ts
resews94814173_rese_ws
resiles74026543_resiles
resmelts1046143_resmelts
resoles73823653_resoles
respell947023_respell_
results739833_results
retell63813643_retell_
reveals103812723_reveals
revels94220573_reve_ls
rewelds11457413_rewelds
roselle7310243_roselle
roselles8310713_roselles
sells55134433___sells
supersells1246463supersells
tramells10327833tramells
tressels8367653tressels
trestles83012553trestles
unsells73210773_unsells
wrestles113310063wrestles

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621727.04620744.0
3Display Results1721720.0632730.2
 (SQL Overall)1786911727.54523683.4
 
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.