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

159 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
poitrel93619(None) 
poitrels1035241poitrels
coistrel1046742coistrel
costrel9310372costrel
dottrel834462dottrel
goitre7349002goitre_
goitres8389562goitres
petrel83111532p_etrel
peytrel1264252peytrel
boatel84314093boat_el
boite74426323boit_e_
boites84322703boit_es
botel75121863bo_t_el
citral81113893_citral
coistrels1145273coistrels
coistril1046773coistril
coital84117053coit_al
control9310693control
costrels1038933costrels
doggrel1033883doggrel
doited85016633doit_ed
dottel73610893do_ttel
dotterel945063dotterel
dottrels963493dottrels
goiter74116203goit_er
goiters84014443goiters
gomerel1036393gomerel
hostel93914153host_el
hotel85520753ho_t_el
kestrel1137113kestrel
kittel10368873_kittel
litre55421463_litre_
litres65220393_litres
loiter64619173loit_er
loitered938183loitered
loiterer837083loiterer
loiters74116613loiters
mitral81314323_mitral
mitre75522423_mitre_
mitred94414343_mitred
mitres83922073_mitres
moire71017323moi_re_
moires8915633moi_res
mongrel1036333mongrel
morel75729093mo__rel
motel76623243mo_t_el
nitre57519683_nitre_
nitres65519333_nitres
nitril62511533_nitril
nostril749303nostril
outre53922203_outre_
paired95017523pai_red
parrel84515983p_arrel
pastel85918713past_el
patrol83213023p_atrol
petrels9279373p_etrels
petrol82714063p_etrol
peytral1287503peytral
peytrels1363373peytrels
philtre12105213philtre_
philtred14114183philtred
philtres1396513philtres
pipistrel1351843pipistrel
pithed124615613p_ithed
pitied94017253p_itied
pitier84019823p_itier
pities83828083p_ities
pitmen102510793p_itmen
pitted94319593p_itted
pixel143911903p_i_xel
podite93315353podit_e_
podites103014733podit_es
poetries10315583poetries
poetry1139383poetr_y
poinded11358973poinded
pointe84619313pointe_
pointed103813983pointed
pointer93814933pointer
pointers103013723pointers
pointes93216753pointes
pointier1038303pointier
pointmen1245423pointmen
poise75127893poi_se_
poised94918473poi_sed
poiser84217243poi_ser
poisers94214433poisers
poises84226543poi_ses
polite83625073polit_e_
politely1347093polit_ely
politer92417073polit_er
polities102722343polities
pomfret1446993pomfret
pommel12277453po_mmel
pontes83627853pont_es
pontil8315463pont_il
poorer82613993po_orer
pore66451263po__re_
pored85234513po__red
pores75849033po__res
portal84218463port_al
ported94223243port_ed
porter84224413port_er
portered112311543portered
porters93722703porters
portray1237483portray
portress1038323portress
posited10511493posit_ed
positron1096903positron
postal84317533post_al
posted93722493post_ed
posteen93512623posteen
poster84129173post_er
postern93615613postern
posters93928013posters
postie84123963postie_
posties93128813posties
postmen113110423postmen
postoral10311723postoral
postural1049203postural
posture9313253posture_
postured1139493postured
posturer1038923posturer
postures10313783postures
poteen83514263po_teen
potful1138083po_tful
pother113818853po_ther
potmen102713093po_tmen
potted94624013po_tted
potteen9319673potteen
potter83926983po_tter
pottered112311663pottered
potterer102310263potterer
potters94024343potters
pottery123011073pottery
pottier93516493pottier
potties93723543potties
pottle84416103pottle_
pottles93816983pottles
potzer174411213po_tzer
poured95116743po_ured
pourer84516043po_urer
pouted94021393pout_ed
pouter83923983pout_er
pouters94221873pouters
poutful1236743poutful
poutier93215323poutier
powered132911643powered
powter114116033powt_er
powters124015663powters
pretzel1835143pretzel
prithee1239933prithee
rostral7311333rostral
soiree62919483soi_ree
sorel56231443so__rel
sorrel6413553so_rrel
titre54619393_titre_
titres64718933_titres
toited74016753toit_ed
wastrel1037553wastrel

Search took 10 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 Limit1340271598.54615683.0
3Display Results1591590.1261261.9
 (SQL Overall)1786911599.07819684.0
 
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.