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

287 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
growth137738(None) 
growths1494421growths
growthy1773281growthy
rowth115713231_rowth
trowth1277881trowth
broth106521092bro_th
crwth1337482cr_wth
drouth104410102drouth
froth115919282fro_th
goth86825082g_o_th
grith95520372gr_ith
groat65531972groat_
groats74816652groats
grot55942052gro_t_
grots65025852gro_ts
grotto7349812grotto
grotty10389832grotty
grouch12318472grouch
grout65330422grout_
grouts75015612grouts
grouty104710982grouty
grow86127302grow__
grower104614932grower
growl96115822grow_l
growls104711112growls
growly13499172growly
grown95317352grow_n
grows95523922grow_s
ingrowth1553012ingrowth
regrowth1544032regrowth
routh86423072_routh
rowths12458172_rowths
troth85622202tro_th
trowths1365022trowths
upgrowth1741952upgrowth
wroth116815882wro_th
agoroth1145133agoroth
azoth17389903azo_th
booth105522013_booth
both96533433_bo_th
breath113916263breath
brith104924373br_ith
broach133611113broach
brooch13368443brooch
broths115013923bro_ths
brothy14519623bro_thy
brow97228443brow__
browed125216393browed
brown105619533brow_n
browns116415633browns
browny144510043browny
brows105425983brow_s
browse115713853browse
cloth105817543clo_th
coolth1139513coolth
couth106122483_couth
croft105622683croft_
crofts114910593crofts
crotch133410083crotch
crouch133910203crouch
croute84617273croute
crow96428133crow__
crowd115815623crow_d
crowds124910763crowds
crowdy15467173crowdy
crowed124717293crowed
crower114117553crower
crown105620083crow_n
crowns115615113crowns
crows105727313crow_s
crwths1433433cr_wths
doeth9411983_doeth
doth86225713_do_th
droit65127123droit_
droits74314313droits
dropt86924433dropt_
drouths11436483drouths
drouthy14395173drouthy
drown95515823drow_n
drownd11478313drownd
drowns105612333drowns
drowse105010553drowse
drowsy13487903drowsy
forth116222673_forth
frith115922033fr_ith
front85029223front_
fronts94415793fronts
frosh115713403fro_sh
frost84727833frost_
frosts94214623frosts
frosty124710633frosty
froths125411443fro_ths
frothy15578373fro_thy
frow106425053frow__
frown115415973frow_n
frowns126011393frowns
frows116623103frow_s
frowst125512073frowst
frowsts13426093frowsts
frowsty16464983frowsty
frowsy15498273frowsy
frowzy24485793frowzy
garote7717943garo_te
garotte868703garotte
garth94720223g_arth
ghost96318763ghost_
ghosts10489273ghosts
ghosty13467213ghosty
girth95618843g_irth
gloat65427683gloat_
gloats74515423gloats
glost65422933glost_
glosts74513813glosts
glout65925813glout_
glouts74414713glouts
glow85222523glow__
glowed114913833glowed
glower105114933glower
glows95518033glow_s
goat56250833g_oat_
goats65527303g_oats
gosh86123423g_o_sh
got49870443g_o_t_
goths96513003g_o_ths
gout56646003g_out_
gouts64826173g_outs
gouty95217363g_outy
gowan95415743g_owan
gowd96519983g_ow_d
gowds105814043g_owds
gowk125516473g_ow_k
gowks136011953g_owks
gown85724073g_ow_n
gowns95115103g_owns
graft95327203graft_
grafts105013253grafts
grant64840023grant_
grants73722473grants
graph115315613gr_aph
grat55651283gr_at_
grate64932883gr_ate
great66034243great_
greats76318393greats
greenth11116723greenth
greet65835323greet_
greets75117423greets
grew85620263grew__
grift95924463grift_
grifts104511683grifts
grinch1238473grinch
griot65328413griot_
griots74713643griots
gript85126173gript_
grist65529873grist_
grists74716483grists
grit55247243gr_it_
griths105211653gr_iths
grits65529583gr_its
gritty10338403gritty
groan65618423gro_an
groans74815063groans
grocer94212143grocer
grody103412063gro_dy
grog65923343gro__g
groggy1234803groggy
grogs76319413gro_gs
groin65521083gro_in
groins73917203groins
grok95819683gro__k
groks105716123gro_ks
groom85317983gro_om
grooms94512523grooms
groove10438873groove
groovy13375403groovy
grope84821613gro_pe
groped107515053groped
groper94517253groper
gropes95220403gropes
gross65421693gro_ss
grosz154814093gro_sz
grosze16457733grosze
groszy19395703groszy
grottos8337333grottos
grouchy16294243grouchy
ground82310273ground
group85413923gro_up
groups94210513groups
grouse74315023grouse
grouted94111503grouted
grouter84412523grouter
grove95219333gro_ve
groved114413703groved
grovel104310543grovel
groves104318103groves
growers113612723growers
growing123512473growing
growled12278163growled
growler11318973growler
grownup1342213grownup
growthier1642203growthier
groyne1037213groyne
grunt65523543grunt_
grunts75511853grunts
grutch12285563grutch
ingrowths1641923ingrowths
liroth938383liro_th
loath84918603_loath
loth76132133_lo_th
month104818423_month
moth96731333_mo_th
mouth105420293_mouth
nongrowth1652573nongrowth
north86018273_north
nowt78833753_nowt_
nowts86915853_nowts
oath76132153__oath
outgrowth1663103outgrowth
pregrowth1852203pregrowth
pronto8313993pronto
prost75434103prost_
prow97030383prow__
prowar114110943prowar
prower114218123prower
prowl105615123prow_l
prowls115511083prowls
prows106327013prow_s
quoth173310353quo_th
rath76037663_r_ath
regrowths1642433regrowths
roach105717003_roach
root45655923_root_
roots55933673_roots
rooty86423023_rooty
rot37282953_ro_t_
rota45834343_ro_ta
rotch105815933_rotch
rote46249023_ro_te
roti46332923_ro_ti
rotl45029683_ro_tl
roto45935053_ro_to
rots46454093_ro_ts
rotte54625933_rotte
rough97819433_rough
rout46153283_rout_
route55132073_route
rouths95416823_rouths
routs57133413_routs
row67453673_row__
rowan85418733_rowan
rowdy125711533_rowdy
rowed94034323_rowed
rowel84721413_rowel
rowen84921153_rowen
rower85430493_rower
rows75941753_row_s
ruth76825993_r_uth
scouth115011153scouth
sloth85019443slo_th
smooth11259193smooth
sooth85924053_sooth
soth75932513_so_th
south85223573_south
tooth88020183_tooth
toroth95512963toroth
trot46351313tro_t_
troths95414153tro_ths
trots56629943tro_ts
trough108512023trough
trout57332573trout_
trouts66116623trouts
trouty95211793trouty
trow78031423trow__
trowed104714653trowed
trowel94211463trowel
trows88826183trow_s
truth85214153tr_uth
upgrowths1851333upgrowths
urolith1048783urolith
vrow105817473vrow__
vrows116115263vrow_s
worth117120523_worth
wraith1258603wraith
wrath115715873wr_ath
wreath124111193wreath
wrote84717483wro_te
youth115315043_youth
zeroth1837963zero_th

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162876.40617595.4
3Display Results2872870.1701688.2
 (SQL Overall)1786912876.71626606.8
 
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.