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

231 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
presell93930(None) 
presells1058281presells
pretell938241pretell
resell64215201_resell
prebill1138802prebill
predella1145392predella
premeal11310522premeal
prepill1147582prepill
presale9416352presale
prese75228382prese__
present94022732present
preset84430982prese_t
presets94216422presets
presold1059602presold
pretells1047332pretells
refell94214442_refell
reseal64819642_reseal
resells73313202_resells
respell947022_respell
retell63813642_retell
ainsell796393ainsell
bedell93610043_bedell
befell11428713_befell
creel75121483cre_e_l
creels84416943cre_els
crenel84213063crene_l
crenelle1046333crenelle
crenels93711013crenels
cresol8310213cres_ol
cresols939653cresols
crestal9312133crestal
cresyl1135133cres_yl
cresyls1234753cresyls
crewel114310483crewe_l
crewels12438493crewels
diesel74410403diese_l
diesels8429143diesels
drywell1442373drywell
erosely1038083erosely
farewell1443313farewell
foretell1146123foretell
freely12310963fre_ely
freshly16286833freshly
fresnel1035893fresnel
fresnels1135233fresnels
harebell1344353harebell
herself1337623herself
obesely1245113obesely
oneself1046073oneself
outsell7109263outsell
oversell1137473oversell
pareses94718883parese_s
passel85117003passe_l
passels93913023passels
peel65535613p_e_e_l
peels75226423p_e_els
persalt9315413persalt
perse75429523perse__
perses85428063perse_s
peseta8310573p_eseta
pesewa1135543p_esewa
pestle83215843p_estle
phaseal1245673phaseal
prase76128753prase__
prases84429023prase_s
preanal9310713preanal
prebend12319443prebend
prebills1237293prebills
preboil1148953preboil
precede1239653precede
precent113520263precent
precept133112513precept
precess11310863precess
prechill1546193prechill
precisely1645353precisely
precool1139013precool
predellas1245283predellas
predial103815413predial
predrill1145933predrill
pree67044733pre_e__
preed85128123pre_e_d
preen75925053pre_e_n
preens85020113pre_ens
prees75937173pre_e_s
prefect141011073prefect
prefer113813203prefe_r
prefers123713333prefers
prefile123413183prefile
preheat12413893preheat
prelect111013833prelect
prelegal1145053prelegal
premed114617763preme_d
premeds12389593premeds
premeet11615153premeet
premen105017803preme_n
premold1247863premold
premolt11312073premolt
preoral9312673preoral
prequel1836343prequel
prequels1934833prequels
prerenal1049083prerenal
presa74319043pres__a
presage10312293presage
presales10315263presales
preselect1346983preselect
preselling1338693preselling
presence122213513presence
presently1449063presently
presents103315643presents
preserve13108803preserve
presettle1145943presettle
preship1439793preship
preshow15237413preshow
preside10715613preside
presift12312223presift
presleep1244493presleep
presoak1348453presoak
presolve1347073presolve
presong1039843presong
presort95219543presort
presplit1247753presplit
press75425953pres__s
pressed103317313pressed
presser93717623presser
pressers103215023pressers
presses93523153presses
pressor93512883pressor
prest75736353pres__t
prester93519623prester
presters103419003presters
presto84216203pres_to
prestos93716083prestos
prests84021263pres_ts
presume11310303presume
preteen939873preteen
pretend104011013pretend
preterm11310163preterm
pretest9517633pretest
pretext1639663pretext
pretold1049083pretold
pretzel1835143pretzel
pretzels1934033pretzels
prevail1238243prevail
prevent124016553prevent
preverb14317063preverb
prexes154915953prexe_s
preyed125313203preye_d
preyer114413733preye_r
preyers124412363preyers
prezes173614693preze_s
priestly1345843priestly
prill74117943pr__ill
primely1457723primely
prise74632613prise__
prised94322203prise_d
prisere9310943prisere
prises84133173prise_s
pronely12310253pronely
propel103714063prope_l
propels113412843propels
prose75835123prose__
prosect11313393prosect
prosed94921093prose_d
proser84223463prose_r
prosers94219643prosers
proses84733473prose_s
prosily12611633prosily
prunella1044073prunella
prunelle1044983prunelle
prunello1043433prunello
rebel73421293_rebe_l
rebels84518133_rebels
rebill84713253_rebill
recall83815723_recall
reel45240533_re_e_l
reels55333263_re_els
refall94314393_refall
refeel93913243_refeel
refel84920813_refe_l
refels94618053_refels
refelt94521423_refelt
refill94514053_refill
reheel93610823_reheel
remelt85123123_remelt
repeal84718283_repeal
repel74921403_repe_l
repels84318763_repels
repoll8410793_repoll
reroll6412683_reroll
resail64418733_resail
resale64025543_resale
reseals73917663_reseals
reseat64131493_reseat
reseau64216213_reseau
resect84424703_resect
reseda739703_reseda
resee54336333_rese_e
reseed74823293_reseed
reseek103813133_reseek
reseen64318413_reseen
resees63827483_resees
reseller83412223_reseller
resend75016773_resend
resent63833623_resent
reset55051863_rese_t
resets65427613_resets
resew84519503_rese_w
resewn9459813_resewn
resews94814173_resews
resile64627673_resile
resmelt9411773_resmelt
resold73915363_resold
resole64624183_resole
respells1056333_respells
respelt9312143_respelt
result6318223_result
retells73211523_retells
reveal94115053_reveal
revel84423163_reve_l
revels94220573_revels
reweld103711113_reweld
roselle7310243_roselle
sell45840613___sell
supersell1147063supersell
tersely1038113tersely
tramell9398703tramell
tressel73010893tressel
tressels8367653tressels
trestle72611363trestle
unsell63512543_unsell
wrestle10298843wrestle

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.470380193.6
2DLD Change Limit1340272317.04619021.7
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.60923484.2
 
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.