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

214 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
daleths113532(None) 
daledhs1232781daledhs
daleth1038631daleth_
alephs1136532_alephs
daledh1133742daledh_
dales66439742dale__s
deletes83117932deletes
palets85122312palet_s
valets93715622valet_s
abets75621673_abet_s
acalephs1542993acalephs
aglets73915683aglet_s
airths95414253_airths
alates64833963_alates
alecs76620733_ale_cs
alefs87319663_ale_fs
aleph10311393_aleph_
alerts64418223_alerts
ales47067103_ale__s
almahs118611613_almahs
almehs11619493_almehs
alters64924223_alters
altho86312603_al_tho
altos55822953_al_tos
alts46639903_al_t_s
aretes64425353_aretes
azoths18366203_azoths
balatas9311833balatas
baleens938473baleens
balers85626933bale_rs
bales76250083bale__s
ballets93719513ballet_s
baths105922923ba__ths
beths105519223__beths
blets75324943_blet_s
boletes9316063boletes
boletus948643boletus
cablets114216343cablet_s
cadets96316513cadet_s
calathi1247583calathi
calathos1347523calathos
calathus1345023calathus
caleche14297943caleche
caleches15269933caleches
calends1039523calends
calesas9411833calesas
caliphs1436753caliphs
callets93821703callet_s
camlets114314623camlet_s
caplets114914523caplet_s
carets85330773caret_s
chalehs15268803chale_hs
chalets122813473chalet_s
cheths14389823_cheths
cloths115512483_cloths
culets85518513culet_s
daces85030683dace__s
dacites101114593dacites
dahs88231813da___hs
dalasis8810533dalasis
dale55643983dale___
dalles74222063dal_les
dallies84023193dallies
dals57145123dal___s
dalton7311273dal_ton
daltons8310403daltons
dames85435853dame__s
darers75921873dare_rs
dares66146703dare__s
darters84017603darters
darts67635733da_rt_s
daters74827373date_rs
dates65639153da__tes
datos65222783da__tos
dattos74311903da_ttos
daunts75014083daunt_s
dauts67822243da_ut_s
davens104612913dave_ns
davits104012363davit_s
dawts97216123da_wt_s
dazes155024143daze__s
dealates92716683dealates
dealers84118613deale_rs
dearths11498843dearths
deaths105914443d_eaths
deets65330243d_eet_s
delates83526283delates
deleads9379703deleads
deles65139253dele__s
delete73620703delet_e
deleted93314903deleted
delfts10439673delft_s
deltas74414823del_tas
delts65731793del_t_s
depletes112810633depletes
depths12428573d_epths
diabetes1147023diabetes
dialects11126003dialects
dialers83614303diale_rs
diets66026643d_iet_s
dilates83220663dilates
dilutes82911973dilutes
doeth9411983d_oeth_
doles67843753dole__s
dolts65626313dol_t_s
dozenths2142793dozenths
drouths11436483drouths
duets65323883d_uet_s
dulcets1046283dulcet_s
duvets1039223duvet_s
eaglets84111663eaglet_s
earths95014593ea_rths
eoliths10318573eoliths
eths76619523___eths
facets116316653facet_s
faiths124610273fa_iths
falters103916473falters
filets94718953filet_s
filths12389783fil_ths
galahs105512673gal_ahs
galeas74618513gale_as
galenas83310343galenas
galeres83514333galeres
gales65442483gale__s
galette84212693galette
galettes93111153galettes
galletas9308133galletas
gallets83517403gallet_s
gametes10312253gametes
garths104111503ga_rths
hadiths1436023hadiths
haets86525123ha_et_s
halers94926913hale_rs
hales85449843hale__s
halites103221193halites
halitus10339963halitus
hallahs133912463hallahs
halters104619803halters
halts85230103hal_t_s
halvahs16417533halvahs
hamlets123211403hamlet_s
haslets102510863haslet_s
healths13478753heal_ths
heths116317783__heths
inlets63915573inlet_s
islets64513083islet_s
kalends1235683kalends
kales95730983kale__s
kaliphs1634293kaliphs
kheths16495973_kheths
lamedhs13444703lamedhs
laths86022403__laths
lethe85717303__lethe
lethes94818083__lethes
lets47147943__let_s
malates93522603malates
maleates103316343maleates
males75049793male__s
mallets93318493mallet_s
malteds10377603malteds
maltha1137503mal_tha
malthas1237913mal_thas
malts76331753mal_t_s
maths105624023ma__ths
meths105320233__meths
muletas937383muletas
naleds7469133nale_ds
oaths86117313oa__ths
ooliths10268323ooliths
owlets93110393owlet_s
palates93624933palates
pales75753803pale__s
palet74650803palet__
paletot9413713paletot
paletots1047803paletots
palette93613983palette
palettes103112833palettes
pallets93919303pallet_s
palters94021683palters
paths105521383pa__ths
rales54947493rale__s
ralphs1135373ral_phs
ramets83517393ramet_s
relets64025673relet_s
saleps85014903sale_ps
sales56055593sale__s
sallets73719653sallet_s
salters73622253salters
salts55431883sal_t_s
salutes73716253salutes
samechs14285353samechs
samekhs16303923samekhs
samlets93813553samlet_s
sleuths1034743_sleuths
sloths94911893_sloths
tablets94714373tablet_s
talents7312013talents
talers64628143tale_rs
tales55451373tale__s
talliths11377433talliths
teths85418513__teths
tilths9459373til_ths
vales85434263vale__s
valet84337873valet__
valeted1139013valeted
valutas1036533valutas
varlets10411573varlet_s
walers94824463wale_rs
wales86142833wale__s
wallahs13409473wallahs
wallets103914833wallet_s
warmths1583783warmths
wealths13365813weal_ths
zibeths2142933zibeths

Search took 7 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.1561145455.1
2DLD Change Limit1340272146.73319906.0
3Display Results2142140.0802675.0
 (SQL Overall)1786912146.96925640.8
 
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.