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

133 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
dottrel83446(None) 
dottel73610891dott_el
dotterel945061dotterel
dottrels963491dottrels
costrel9310372costrel
doggrel1033882doggrel
dotted84717522dott_ed
dottels8327782dott_els
dotter74419342dott_er
dotterels1043902dotterels
dotters83715972dotters
dottier83910922dottier
dottle74212502dottle_
dottles83912282dottles
poitrel936192poitrel
boatel84314093boat_el
botel75121863bo_t_el
bottle84916073bottle_
bottled104611233bottled
bottler94211883bottler
bottles94216273bottles
coistrel1046743coistrel
control9310693control
costrels1038933costrels
cottae84615703cottae_
cotter84926673cott_er
cottered112511733cottered
cotters94323443cotters
cottier93814173cottier
dextral1577003dextral
dioptral1144683dioptral
dioptre1055763dioptre_
dioptres1146113dioptres
ditties83116983ditties
dittoed936733dittoed
doated84118183doat_ed
doctoral1146303doctoral
doctored1245613doctored
doggerel1143453doggerel
doggrels1142633doggrels
dogtrot947443dogtrot
doited85016633doit_ed
donzel1636313do_nzel
dore56353303do__re_
dorsel75315503do_rsel
dossel74813643do_ssel
dotage82711613dotage_
dotages92311793dotages
dotal64919623do_t_al
dotard839053dotar_d
dotardly1343843dotardly
dotards937253dotards
dote55442883do_t_e_
doted75227073do_t_ed
doter65428623do_t_er
doters74423913doter_s
dotes65836693do_t_es
dotier73917033do_tier
dottiest92611393dottiest
dottily1147283dottily
dotting93314483dotting
dotty94516103dott__y
dourer74215273do_urer
dowel95618193do__wel
dowered122811553dowered
goitre7349003goitre_
goitres8389563goitres
gomerel1036393gomerel
gotten73410113gott_en
hostel93914153host_el
hotel85520753ho_t_el
hotted104319943hott_ed
hotter94720083hott_er
hottie92514383hottie_
hotties103016963hotties
jotted143615173jott_ed
jotter134315633jott_er
jotters143413803jotters
kestrel1137113kestrel
kittel10368873kitt_el
lotte54923853lott_e_
lotted74222403lott_ed
lotter64025603lott_er
lotters73921063lotters
lottery10389833lottery
lottes65322753lott_es
mongrel1036333mongrel
morel75729093mo__rel
motel76623243mo_t_el
motored1039933motored
motte75526973mott_e_
mottes85523693mott_es
mottle84116053mottle_
mottled10409973mottled
mottler94410343mottler
mottles93415803mottles
mottoes93412193mottoes
nostril749303nostril
otter54423973_ott_er
otters64021513_otters
outre53922203_outre_
petrel83111533_petrel
peytrel1264253peytrel
poitrels1035243poitrels
potted94624013pott_ed
potteen9319673potteen
potter83926983pott_er
pottered112311663pottered
potterer102310263potterer
potters94024343potters
pottery123011073pottery
pottier93516493pottier
potties93723543potties
pottle84416103pottle_
pottles93816983pottles
rostral7311333rostral
rotte54625933rott_e_
rotted74524433rott_ed
rotten64115433rott_en
rotter64325463rott_er
rotters74421393rotters
rottes64524833rott_es
sorel56231443so__rel
sorrel6413553so_rrel
sotted74121403sott_ed
totted74319953tott_ed
totter65021463tott_er
tottered9208703tottered
totterer8217793totterer
totters74618733totters
tottery10388483tottery
wastrel1037553wastrel
wotted104115713wott_ed

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.393454684.5
2DLD Change Limit1340271336.59320328.7
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.03225411.1
 
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.