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

442 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
goitre734900(None) 
goiter74116201goiter
goitres8389561goitres
boite74426322boit_e
gaiter73819502gaiter
gite55438612g_it_e
goatee73219532goatee
goiters84014442goiters
gore55744962go__re
litre55421462_litre
loiter64619172loiter
mitre75522422_mitre
moire71017322moi_re
nitre57519682_nitre
outre53922202_outre
poitrel936192poitrel
titre54619392_titre
afire86215913afi_re
antre55224523_antre
aortae65115473aortae
attire62412383attire
axite125218253axit_e
baiter84422553baiter
bistre83815023bistre
bite66547003_bit_e
biter75030033_biter
blite76225353blit_e
blithe115810863blithe
boater84622093boater
boiler84319273boiler
boites84322703boites
bolter83920753bolter
bootee84323023bootee
bootie85421163bootie
bore66051333bo__re
bottle84916073bottle
centre84316643centre
chirre114111853chirre
cire65836373_ci_re
cite65640343_cit_e
citer74827333_citer
coatee84327223coatee
coater84329573coater
cohere112716993cohere
coiffe1447043coiffe
coigne94612193coigne
coiler84421593coiler
coiner84323783coiner
cointer93616723cointer
coir66327243coi_r_
coirs75221053coi_rs
coistrel1046743coistrel
coital84117053coital
coitus8511893coitus
colter84625093colter
colure8314163colure
comte96125473comt_e
conte76633203cont_e
contra83314703contra
cooter85128613cooter
cootie84223093cootie
copter109822013copter
core67263113co__re
costae85319683costae
coster84331293coster
costrel9310373costrel
cote66648733co_t_e
cottae84615703cottae
cotter84926673cotter
couter84930223couter
couture9310623couture
dioptre1055763dioptre
dire56644143_di_re
dite55547553_dit_e
doit56347853doit__
doited85016633doited
doits66223673doit_s
dore56353303do__re
dote55442883do_t_e
doter65428623do_ter
dotier73917033dotier
dotter74419343dotter
dottle74212503dottle
dottrel834463dottrel
elite56230183elit_e
emigre937053emigre
entire61617703entire
evite85317683evit_e
fibre104812843_fibre
fire76245593_fi_re
flite85424963flit_e
foible11410383foible
fomite113314073fomit_e
footer94320773footer
footie94718143footie
footle93914383footle
fore78351473fo__re
forte86131463fort_e
foster94322223foster
gainer74117493gainer
gait56150193gait__
gaited84416923gaited
gaiters83516543gaiters
gaits65726013gait_s
galere73716683galere
galore73514873galore
gantry103810113gantry
garter74420513garter
gaster75027353gaster
gastrea847243gastrea
gate55746573g_at_e
gater64533653g_ater
geniture946453geniture
genre66016803g_enre
gentle74014513gentle
gentry103410443gentry
geste65920693gest_e
gesture839243gesture
getter74117613getter
gibe75927783g_i_be
giber85417703g_iber
gie47149543g_i__e
giftee103512083giftee
gighe10139733g_ighe
gigue71210673g_igue
gimme102411343g_imme
gird65424993g_i_rd
girl56226553g_i_rl
girn56026863g_i_rn
giro55828633g_i_ro
girt56646423g_i_rt
girted83912873g_irted
girth95618843g_irth
girts65423623g_irts
git46266053g_it__
gites65630183g_ites
gits55744593g_it_s
gitted84015053g_itted
give85829353g_i_ve
giver94921203g_iver
glaire74411303glaire
glare65222963g_lare
glide74521593gli_de
glider84614263glider
glime85620193gli_me
glister84013343glister
glitch12286353glitch
glitter84211803glitter
glitz154916373glit_z
glitzed18375493glitzed
glitzes17367563glitzes
glitzy19404783glitzy
gloater83711013gloater
glute66020903glut_e
goalie7413163goalie
goat56250833goat__
goateed9307063goateed
goatees82710443goatees
goats65527303goat_s
gobble113512983gobble
goer56827103go_er_
goers65520253go_ers
gofer94814283gofer_
gofers104711513gofers
goffer13409513goffer
goggle94511573goggle
going75218493goi_ng
goings84911523goings
goitrogen1152203goitrogen
goitrous945763goitrous
golder84417603golder
golfer104411183golfer
goliard936073goliard
gomer85220653gomer_
gomerel1036393gomerel
gomers94116883gomers
gone55639043go__ne
goner66025163goner_
goners74420173goners
goober93911743goober
goodie83613993goodie
gooier73516213gooier_
goonie73615563goonie
goose65925903go_ose
gopher1239183gopher
gor47848263go__r_
gored75227083go__red
gores65740373go__res
gorge76423893go_rge
gorger86116983gorger
gorier73719373gorier_
gorm75529393go__rm
gorp75625903go__rp
gorse65926813go_rse
gory86129663go__ry
got49870443go_t__
goth86825083go_t_h
gothite1146403gothit_e
goths96513003go_ths
gotten73410113gotten
gouge78220063go_uge
gouger86014363gouger
gourd71011903go_urd
gourde8107933gourde
gout56646003gout__
goutier82612353goutier
gouts64826173gout_s
gouty95217363gout_y
govern1036823govern
grate64932883grat_e
grater74625443grater
gride75223583gri_de
grieve1047243grieve
griffe13438093griffe
grifter113810493grifter
grigri833853grigri
grille74315743grille
grilse7399503grilse
grime85021323gri_me
gripe84622963gri_pe
griper94114613griper
grippe115310323grippe
grister83915413grister
gristle8169223gristle
grit55247243grit__
grith95520373grit_h
griths105211653griths
grits65529583grit_s
gritted94110903gritted
gritter83913353gritter
gritty10338403gritty
grouter84412523grouter
guide75019883gui_de
guider84313523guider
guile64521133gui_le
guimpe1134723guimpe
guipure1043533guipure
guiro63712093gui_ro
guise64717713gui_se
guitar7117443guitar
guitars8116863guitars
gumtree1045873gumtree
gunite7414403gunit_e
guttae73210583guttae
gutter73817713gutter
guttle74111973guttle
gwine95513663gwi_ne
gyre84722763g__yre
hire75538963_hi_re
hogtie102711773hogtie
hoise85224773hoi_se
hoister103714203hoister
hombre13309303hombre
hooter94123933hooter
hotter94720083hotter
hottie92514383hottie
ignite71410583ignit_e
igniter8147673igniter
iolite63221983iolit_e
ire36943173__i_re
joiner134114133joiner
jointer14379713jointer
jointure15134833jointure
jolter133513093jolter
jostle13319863jostle
jotter134315633jotter
kite85338243_kit_e
kiter95523213_kiter
kithe125917453_kithe
koine9516483koi_ne
kore85834163ko__re
lire47845293_li_re
lite47054543_lit_e
liter54736343_liter
lithe84922013_lithe
litres65220393_litres
livre85613253_livre
loathe94211383loathe
lofter94614723lofter
loitered938183loitered
loiterer837083loiterer
loiters74116613loiters
looter64222323looter
lore45850353lo__re
lotte54923853lo_tte
lotter64025603lotter
louvre9425683louvre
lustre64011683lustre
maigre9309163maigre
metre74821303_metre
mire66748233_mi_re
mite66249413_mit_e
miter75734793_miter
mitred94414343_mitred
mitres83922073_mitres
moidore1056153moidore
moiler84017263moiler
moira71012023moi_ra
moires8915633moi_res
moister94015373moister
moisture1046653moisture
molter84119423molter
monte75829773mont_e
mooter83921093mooter
more67154523mo__re
moste75925083most_e
mote67048083mo_t_e
motile83818343motile
motive113112143motive
motte75526973mo_tte
mottle84116053mottle
nite45943583_nit_e
niter55028973_niter
nitres65519333_nitres
nitro54914353_nitro
noir46722433noi_r_
noirs55615463noi_rs
noise55723733noi_se
norite63221133norit_e
note46239963no_t_e
noter55025643no_ter
notice8313443notice
oater55433733_oater
ochre103411593_ochre
ofter84116873_ofter
ogive9379093ogi_ve
ogre56320743_o_gre
oiler54628283_oiler
ombre94111803_ombre
oolite63319603oolit_e
ore36661833_o__re
otter54423973_otter
outer55633303_outer
oxter123414093_oxter
philtre12105213philtre
podite93315353podit_e
poetry1139383poetry
pointe84619313pointe
pointer93814933pointer
poise75127893poi_se
poiser84217243poiser
poitrels1035243poitrels
polite83625073polit_e
politer92417073politer
pore66451263po__re
porter84224413porter
poster84129173poster
postie84123963postie
posture9313253posture
potter83926983potter
pottle84416103pottle
pouter83923983pouter
powter114116033powter
quatre153512353quatre
quire144917133qui_re
quite144621463quit_e
retire64927013retire
rioter64817283rioter
rite45849453_rit_e
roister73516203roister
rooter64926033rooter
rootle63214453rootle
roster64329083roster
rostra6310933rostra
rote46249023ro_t_e
rotte54625933ro_tte
rotter64325463rotter
route55132073rout_e
router65025843router
saithe94713913saithe
satire63218003satire
shire84727133shi_re
sire46150413_si_re
site47052413_sit_e
skite95120053skit_e
smite75224873smit_e
smiter83616413smiter
softer94015313softer
softie93312483softie
soigne74310033soigne
soilure736233soilure
soiree62919483soiree
sombre10729473sombre
somite84519373somit_e
soothe94214853soothe
sopite84917713sopit_e
sore47059533so__re
sorter64425093sorter
sortie63621993sortie
souter64225923souter
spire75828693spi_re
spite75430663spit_e
suite54829563suit_e
suiter64121813suiter
swithe124010683swithe
tire46143353_ti_re
titer55430613_titer
tithe85319703_tithe
title54721073_title
titres64718933_titres
toile54626493toi_le
toiler63918283toiler
toit46353063toit__
toited74016753toited
toits55327473toit_s
tooter64420803tooter
tootle62613813tootle
tore47359323to__re
torte55431703tort_e
torture738593torture
tote46643673to_t_e
toter55932133to_ter
totter65021463totter
touter63821033touter
trite54730033trit_e
triter65120593triter
unite54828383unit_e
uniter64619143uniter
unmitre936993unmitre
vitae84217633_vitae
voice104915323voi_ce
voicer113910543voicer
voider103611553voider
voile84719723voi_le
volte85321303volt_e
vomiter1237953vomiter
vote74728623vo_t_e
voter85121053vo_ter
votive12348933votive
waiter94321253waiter
white114920303whit_e
whiter124316393whiter
wire75839813_wi_re
wite75443273_wit_e
withe115220233_withe
wore77144673wo__re
write85522833writ_e
writer94416513writer
writhe125310703writhe
yore76335943yo__re
zaire14311993zai_re
zoster153715853zoster

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.376475242.0
2DLD Change Limit1127164425.42020796.3
3Display Results4424420.1263507.9
 (SQL Overall)1786914425.92230174.1
 
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.