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

222 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
zeroth183796(None) 
berth104917882ber_th
betroth1247542betroth
broth106521092_broth
froth115919282_froth
liroth938382liroth
toroth95512962toroth
troth85622202_troth
wroth116815882_wroth
zenith1839072zenith
zero134822462zero__
zeroed16409412zeroed
zeroes154314342zeroes
zeros144918102zero_s
aerate64830553aerate
aero45435343aero__
aerobe8412403aerobe
aerolith1149833aerolith
agoroth1145133agoroth
airth85621023air_th
azoth17389903_azoth
begot84625953begot_
berate84729023berate
beret74946363beret_
berets85822523berets
bertha11429173ber_tha
berths114712423ber_ths
besot76429713besot_
besots86415453besots
beth96629233be__th
betroths1345633betroths
birth105619873bir_th
booth105522013_booth
both96533433__both
breath113916263breath
brith104924373_brith
broths115013923_broths
brothy14519623_brothy
caroch13911763caroch
cenote83715843cenote
cerate84829463cerate
ceriph1398463ceriph
cerite84724873cerite
cero66329453cero__
ceros74726073cero_s
cerotic11415053cerotic
cerous85821203cerous
cloth105817543_cloth
crotch133410083_crotch
crwth1337483_crwth
dearth104212513dearth
death94822523de_ath
demote94817803demote
denote74118043denote
depot85727923depot_
depots94716343depots
depth114311853de_pth
derat65044083derat_
derate74531233derate
derats74625063derats
devote104513783devote
doth86225713__doth
drouth104410103_drouth
earth85023053_earth
eath75735663_e_ath
emote75421193_emote
epoch1248203_epoch
ergot65422893_ergot_
ergots74512373_ergots
erode64520993_erode
eros45238453_ero_s
erose55727273_erose
erotic82620263_erotic
erst47436433_erst_
eth66630983_e__th
ferity122813343ferity
firth115819533fir_th
forth116222673for_th
frith115922033_frith
frosh115713403_frosh
froths125411443_froths
frothy15578373_frothy
garote7717943garote
garth94720223gar_th
gemot84024233gemot_
gemote94613023gemote
gemots93712153gemots
gerah9315303ger_ah
girth95618843gir_th
goth86825083__goth
grith95520373_grith
grot55942053_grot_
grots65025853_grots
growth1377383_growth
health124712143health
hearth125315213hearth
heath115724283he_ath
helot85332683helot_
helots95217703helots
hereto9313693hereto
heriot9422343heriot_
heriots10312063heriots
hero74635783hero__
heroes94923823heroes
heroic113516923heroic
heroin94420593heroin
heron85025503hero_n
herons94820543herons
heros84930863hero_s
hertz174919033her_tz
heth107028023he__th
length1046103length
lirot5430033lirot_
loth76132133__loth
merch125417963mer_ch
merit7339183merit_
merits8320873merits
merlot83217603merlot_
merlots92710123merlots
meth95827843me__th
mirth106418893mir_th
moth96731333__moth
neath86020283ne_ath
nerol51017813nero_l
neroli61111153neroli
nerols6914883nerols
nerts55924983ner_ts
nertz145117453ner_tz
north86018273nor_th
pelota8612833pelota
perch124518833per_ch
perish114619063perish
periti8319953periti
peroxy1838243peroxy
pert66759323per_t_
peyote1139853peyote
peyotl1146233peyotl
quoth173310353_quoth
rath76037663__rath
regrowth1544033regrowth
remote84222603remote
repot75132623repot_
repots85621003repots
reroll6412683reroll
reroof9315003reroof
rerose63320843rerose
reroute7313963reroute
revote94917453revote
rewrote1039113rewrote
rot37282953__rot_
rota45834343__rota
rotch105815933__rotch
rote46249023__rote
roti46332923__roti
rotl45029683__rotl
roto45935053__roto
rots46454093__rots
routh86423073__routh
rowth115713233__rowth
ruth76825993__ruth
scrota8310183scrota
seraph114011163seraph
serosa6313023serosa
serous65023563serous
serow86720443sero_w
serows96016393serows
sloth85019443_sloth
smooth11259193smooth
sooth85924053_sooth
soth75932513__soth
strath93216363strath
tarot55943933tarot_
tarots66422993tarots
teeth87315853te_eth
tenth85421833te_nth
teraph11319093teraph
terete6319333terete
teth76327883te__th
tooth88020183_tooth
torot56139943torot_
trot46351313_trot_
troths95414153_troths
trots56629943_trots
trowth1277883_trowth
truth85214153_truth
verite94323443verite
verity123714853verity
vermouth1643763vermouth
vermuth1543533vermuth
verst84429373verst_
verste94515633verste
versts93914733versts
vert77249373ver_t_
verts85724733ver_ts
vertu85017613ver_tu
warmth1477933warmth
wealth12379223wealth
wert79749823wer_t_
worth117120523wor_th
wrath115715873_wrath
wreath124111193wreath
wrote84717483_wrote
xerotic16410853xerotic
xerox1138623xero_x
yirth116513753yir_th
zealot15313473zealot_
zealots1636763zealots
zebroid1936463zebroid
zeniths1935153zeniths
zerk175319253zer__k
zerks185113823zer_ks
zeroing1738343zeroing
zest136035703ze_st_
zests145419743ze_sts
zesty176512163ze_sty
zeta135121643ze__ta
zibeth2034173zibeth
zizith1744823zizith
zlote143912943z_lote
zloty17399793z_loty
zooty175415353z_ooty
zygote19325483zygote

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162227.00016102.3
3Display Results2222220.0633523.8
 (SQL Overall)1786912227.20324807.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.