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 “goiter” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
goiter7411620(None) 
gaiter73819501gaiter
goiters84014441goiters
goitre7349001goitre
loiter64619171loiter
baiter84422552baiter
biter75030032_biter
boater84622092boater
boiler84319272boiler
boite74426322boite_
boites84322702boites
bolter83920752bolter
citer74827332_citer
coater84329572coater
coiler84421592coiler
coiner84323782coiner
cointer93616722cointer
colter84625092colter
cooter85128612cooter
copter109822012copter
coster84331292coster
cotter84926672cotter
couter84930222couter
doited85016632doited
doter65428622do_ter
dotier73917032dotier
dotter74419342dotter
footer94320772footer
foster94322222foster
gainer74117492gainer
gaited84416922gaited
gaiters83516542gaiters
garter74420512garter
gaster75027352gaster
gater64533652g_ater
getter74117612getter
giber85417702g_iber
gite55438612g_ite_
gites65630182g_ites
giver94921202g_iver
glider84614262glider
glister84013342glister
glitter84211802glitter
gloater83711012gloater
goatee73219532goatee
goer56827102go__er
gofer94814282go_fer
goffer13409512goffer
goitres8389562goitres
golder84417602golder
golfer104411182golfer
gomer85220652go_mer
goner66025162go_ner
goober93911742goober
gooier73516212gooier
gopher1239182gopher
gorger86116982gorger
gorier73719372gorier
gotten73410112gotten
gouger86014362gouger
goutier82612352goutier
grater74625442grater
grifter113810492grifter
griper94114612griper
grister83915412grister
gritter83913352gritter
grouter84412522grouter
guider84313522guider
guitar7117442guitar
gutter73817712gutter
hoister103714202hoister
hooter94123932hooter
hotter94720082hotter
igniter8147672igniter
joiner134114132joiner
jointer14379712jointer
jolter133513092jolter
jotter134315632jotter
kiter95523212_kiter
liter54736342_liter
lofter94614722lofter
loiters74116612loiters
looter64222322looter
lotter64025602lotter
miter75734792_miter
moiler84017262moiler
moister94015372moister
molter84119422molter
mooter83921092mooter
niter55028972_niter
noter55025642no_ter
oater55433732_oater
ofter84116872_ofter
oiler54628282_oiler
otter54423972_otter
outer55633302_outer
oxter123414092_oxter
pointer93814932pointer
poiser84217242poiser
politer92417072politer
porter84224412porter
poster84129172poster
potter83926982potter
pouter83923982pouter
powter114116032powter
rioter64817282rioter
roister73516202roister
rooter64926032rooter
roster64329082roster
rotter64325462rotter
router65025842router
smiter83616412smiter
softer94015312softer
sorter64425092sorter
souter64225922souter
suiter64121812suiter
titer55430612_titer
toiler63918282toiler
toited74016752toited
tooter64420802tooter
toter55932132to_ter
totter65021462totter
touter63821032touter
triter65120592triter
uniter64619142uniter
voicer113910542voicer
voider103611552voider
vomiter1237952vomiter
voter85121052vo_ter
waiter94321252waiter
whiter124316392whiter
writer94416512writer
zoster153715852zoster

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511332.57632046.2
3Display Results1331330.0632111.1
 (SQL Overall)1786911332.98259923.2
 
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.