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

116 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
daledhs123278(None) 
daledh1133741daledh_
daleths1135321daleths
alephs1136532_alephs
dales66439742dale__s
daleth1038632daleth_
lamedhs13444702lamedhs
naleds7469132naled_s
acalephs1542993acalephs
aedes64625153_a_edes
albedos1075253_albedos
alders74218423_alders
alecs76620733_ale_cs
alefs87319663_ale_fs
aleph10311393_aleph_
alerts64418223_alerts
ales47067103_ale__s
almahs118611613_almahs
almehs11619493_almehs
balds85524643bal_d_s
baled85436443baled__
baleens938473baleens
balers85626933bale_rs
bales76250083bale__s
caleche14297943caleche
caleches15269933caleches
calends1039523calends
calesas9411833calesas
caliphs1436753caliphs
chalehs15268803chale_hs
daces85030683dace__s
dadas75819863da__das
dados75522433da__dos
dads67442773da__d_s
daedal849083da_edal
dahs88231813da___hs
dalasis8810533dalasis
dale55643983dale___
dalles74222063dal_les
dallies84023193dallies
dals57145123dal___s
daltons8310403daltons
dames85435853dame__s
danders93921183danders
dared75935013dared__
darers75921873dare_rs
dares66146703dare__s
dated75530993dated__
datedly1236023datedly
daters74827373date_rs
dates65639153date__s
davens104612913dave_ns
dawed106222813dawed__
daybeds14234473daybed_s
dazed165919363dazed__
dazedly2134063dazedly
dazes155024143daze__s
dealers84118613deale_rs
deeds75423763d_eed_s
deleads9379703deleads
deled75326543deled__
deles65139253dele__s
deletes83117933deletes
deludes91810643deludes
dialects11126003dialects
dialed84716453dialed__
dialers83614303diale_rs
dildos8179303dil_dos
doled75430913doled__
doles67843753dole__s
edhs86212103___edhs
galahs105512673gal_ahs
galeas74618513gale_as
galenas83310343galenas
galeres83514333galeres
gales65442483gale__s
gledes84915133_gledes
gleds75417893_gled_s
haled95335823haled__
halers94926913hale_rs
hales85449843hale__s
halides113416663halides
halids104016133halid_s
hallahs133912463hallahs
halvahs16417533halvahs
kalends1235683kalends
kales95730983kale__s
kaliphs1634293kaliphs
lamedh12476363lamedh_
lameds94812033lamed_s
males75049793male__s
malteds10377603malted_s
naled65525053naled__
paled85538723paled__
pales75753803pale__s
palets85122313pale_ts
rales54947493rale__s
ralphs1135373ral_phs
salads75316963salad_s
saleps85014903sale_ps
sales56055593sale__s
samechs14285353samechs
samekhs16303923samekhs
sayeds10469253sayed_s
sleds64418853_sled_s
talents7312013talents
talers64628143tale_rs
tales55451373tale__s
teledus835093teledus
toledos8388863toledos
vales85434263vale__s
valets93715623vale_ts
waled94330993waled__
walers94824463wale_rs
wales86142833wale__s
wallahs13409473wallahs

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.436409841.7
2DLD Change Limit1340271166.70319995.1
3Display Results1161160.0303866.7
 (SQL Overall)1786911167.16924925.5
 
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.