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

377 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
toroth9551296(None) 
tooth88020181to_oth
torot56139941torot_
troth85622201t_roth
agoroth1145142agoroth
booth105522012bo_oth
broth106521092_broth
forth116222672for_th
froth115919282_froth
liroth938382liroth
north86018272nor_th
sooth85924062so_oth
tarot55943932tarot_
tarots66422992tarots
toot45958882to_ot_
tooths96013802to_oths
toothy12529692to_othy
toots55331872to_ots
torah87125272tor_ah
torch107420932tor_ch
toro48045682toro__
toroid7416012toroid
toros54336192toro_s
torose64317692torose
torous64319032torous
tort46967462tor_t_
torta55925352tor_ta
torte55431702tor_te
torts56138122tor_ts
trot46351312t_rot_
troths95414152t_roths
trots56629942t_rots
trowth1277882trowth
truth85214152t_ruth
worth117120522wor_th
wroth116815882_wroth
zeroth1837962zeroth
agorot7415003agorot_
airth85621023air_th
aorta55922573aor_ta
azoth17389903_azoth
berth104917883ber_th
betroth1247543betroth
birth105619873bir_th
boot67759373bo_ot_
booths115313793bo_oths
boots75837973bo_ots
booty106125913bo_oty
borate85026153borate
boron76727143boro_n
borons85520543borons
borough1344513borough
borsch1336133borsch
borsht11813503borsht
bort65960963bor_t_
borts76735453bor_ts
borty105522833bor_ty
bortz165722203bor_tz
both96533433__both
brith104924373_brith
brooch13368443brooch
broths115013923_broths
brothy14519623_brothy
caroch13911763caroch
cloth105817543_cloth
cohosh14517123cohosh
cometh134811683cometh
cooch124916833co_och
coolth1139513coolth
coot67860383co_ot_
coots75636843co_ots
corody12149703corody
corona83817403corona
couth106122493co_uth
cowrote12289673cowrote
coyote11411783coyote
crotch133410083_crotch
crwth1337483_crwth
doeth9411983do_eth
dorty96220813dor_ty
doth86225713__doth
drouth104410103drouth
earth85023053ear_th
eolith93013903eolith
firth115819533fir_th
foot76248013fo_ot_
foots85528283fo_ots
footy115820533fo_oty
forgot104318133forgot_
forsooth1444083forsooth
fort76456443for_t_
forte86131463for_te
forts86034453for_ts
forty114824273for_ty
fourth12357443fourth
frith115922033_frith
frosh115713403_frosh
froths125411443_froths
frothy15578373_frothy
garote7717953garote
garth94720223gar_th
girth95618843gir_th
golosh1036463golosh
gonoph1235403gonoph
goth86825083__goth
grith95520373_grith
grot55942053_grot_
grots65025853_grots
growth1377383growth
haftoroth1852653haftoroth
hooch135813703ho_och
hoorah124411113hoorah
hoot75752103ho_ot_
hootch14386413ho_otch
hoots84830253ho_ots
hooty115022443ho_oty
horah117922053hor_ah
horst85833513horst_
horste94817413horste
horsts95817513horsts
korat94934433korat_
korats105416063korats
lirot5430033lirot_
loath84918603lo_ath
loot46955823lo_ot_
loots55431423lo_ots
loth76132133__loth
mirth106418893mir_th
moloch1356483moloch
month104818423mo_nth
mooch125313613mo_och
moot67653623mo_ot_
moots75831663mo_ots
moron76925423moro_n
morons84919543morons
morose85116243morose
morph121712513mor_ph
mort66758833mor_t_
morts75533563mor_ts
moth96731333__moth
mouth105420293mo_uth
norite63221133norite
norths96812323nor_ths
oath76132153_o_ath
ooh67637093_o_o_h
oolith93813243oolith
oot311274693_o_ot_
oots46446443_o_ots
orach105219233_orach
orate55133303_orate
ort39465233_or_t_
ortho8312293_or_tho
orts46538333_or_ts
otolith10108283otolith
pooch124815303po_och
pooh96027383po_o_h
porch125918623por_ch
porose84818743porose
porous84419483porous
port66059633por_t_
ports75934593por_ts
quoth173310353_quoth
rath76037663__rath
robot7325973robot_
robots8313153robots
root45655923ro_ot_
roots55933673ro_ots
rooty86423023ro_oty
rot37282953__rot_
rota45834343__rota
rotch105815933__rotch
rote46249023__rote
roti46332933__roti
rotl45029683__rotl
roto45935053__roto
rots46454093__rots
routh86423073ro_uth
rowth115713233ro_wth
ruth76825993__ruth
scrota8310203scrota
shofroth1742183shofroth
sloth85019453_sloth
smooth11259203smooth
soot45761063so_ot_
soothe94214853so_othe
sooths95715593so_oths
soots55536213so_ots
sooty84924843so_oty
soroche1237183soroche
sort46264813sor_t_
sorta57125413sor_ta
sorts54536663sor_ts
soth75932523__soth
south85223573so_uth
strath93216373strath
taro46846913taro__
taroc75721643taro_c
tarocs84615663tarocs
tarok97921073taro_k
taroks106115283taroks
taros55640823taro_s
tart47566183tar_t_
tarts57242023tar_ts
tarty86328183tar_ty
teeth87315853t_eeth
tenth85421833t_enth
teraph11319093teraph
terete6319333terete
teth76327893t__eth
thorite10313443thorite
thoro86217873thoro__
thoron94713903thoro_n
thorons104511913thorons
thorough15684123thorough
thrash12258363thrash
thresh12276863thresh
thro77726423thro__
throat94819753throat
throats104612193throats
throaty13428483throaty
throb109816853thro_b
throbs118311373throbs
throe89321423thro_e
throes97518673throes
throne98517603throne
throng10539973throng
through141647513through
throve128012393throve
throw118719733thro_w
thrown1214911443thrown
throws129715233throws
thrush12257483thrush
tilth85515363t_ilth
timothy1543233timothy
tiro46832363tiro__
tiros54524893tiro_s
toast55831013toast_
toasts65914993toasts
toasty9509563toasty
toft77441653to_ft_
tofts84919243to_fts
togate74515683togate
toit46353063to_it_
toits55327473to_its
tolbooth13163743tolbooth
tomato8313453tomato
tonish93415903tonish
too38965423to_o__
took86531073to_o_k
tool46735683to_o_l
tools55325243to_ols
toom66532933to_o_m
toon47740633to_o_n
toons55027533to_ons
tooted74620123to_oted
tooter64420803to_oter
toothed113310243to_othed
tootle62613813to_otle
tootsy9437983to_otsy
toph96326873t__oph
topnotch1542333topnotch
topo66932403topo__
topoi76018353topo_i
topos75726393topo_s
tor39261683tor___
tora47545993tor__a
torahs95115643torahs
toras55540373tor_as
torc66333353tor__c
torchy14549533torchy
torcs75123763tor_cs
tore47359323tor__e
torero6313203torero
tores55352673tor_es
tori47542153tor__i
toric76529313tor_ic
torics85118353torics
tories65435883tories
torii55521593tor_ii
torn46044253tor__n
toroids8310643toroids
torosity1147243torosity
torpid9310913torpid
torpor839193torpor
torpors939383torpors
torque15237673torque
torr45630903tor__r
torrid7311853torrid
torrs53923563tor_rs
tors46157383tor__s
torse55833333tor_se
torses64727953torses
torsi57423363tor_si
torsk94915773tor_sk
torsks10549123torsks
torso56922143tor_so
torsos64815733torsos
tortas64918253tortas
torten65314353torten
tortes64826053tortes
tortoni738033tortoni
torula6610393torula
torus54329763tor_us
tory75840543tor__y
tosh74826813t__osh
tost48351923to_st_
tot38884773t__ot_
tote46643673t__ote
tots46654123t__ots
touch106519393to_uch
tough97321983to_ugh
tout46753823to_ut_
touts54830393to_uts
towpath1544043towpath
towrope1245583towrope
toxoid1438153toxoid
toyish122911123toyish
toyo76925453toyo__
toyon86715673toyo_n
toyons95512133toyons
toyos87519143toyo_s
trash86119763t_rash
tret46653533t_ret_
trets55928023t_rets
trite54730033t_rite
troak95213573t_roak
troche113112513t_roche
trock114817603t_rock
trod57627953t_ro_d
trode65322853t_rode
trog57628213t_ro_g
trogs67022603t_rogs
trois57226093t_rois
troke94821053t_roke
troll54416533t_roll
tromp95815803t_romp
trona54118953t_rona
trone55131863t_rone
troop76417533t_roop
troops85712783troops
trooz145016153t_rooz
trop66833303t_ro_p
trope75725803t_rope
trophy1438283t_rophy
trothed114010973t_rothed
trotyl9236673t_rotyl
trough108512023trough
trout57332573t_rout
trouts66116633trouts
trouty95211793trouty
trove85221923t_rove
trow78031423t_ro_w
trows88826183t_rows
trowths1365023trowths
troy77429683t_ro_y
troys86418613t_roys
truths9449503t_ruths
turbeth1274713turbeth
turbith1267113turbith
turbot8914263turbot_
turbots988023turbots
turpeth1284813turpeth
tyro76622363tyro__
tyros85118593tyro_s
warmth1477933warmth
woosh113710733wo_osh
worst86330133worst_
worsts96014333worsts
wort76654753wor_t_
worths127812893wor_ths
worthy15598803wor_thy
worts88631183wor_ts
wrath115715873_wrath
wrote84717483_wrote
yirth116513753yir_th
youth115315043yo_uth
zooty175415353zo_oty

Search took 6 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.373479064.3
2DLD Change Limit1127163775.34621084.2
3Display Results3773770.1233065.0
 (SQL Overall)1786913775.84230587.3
 
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.