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

135 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
goths9651300(None) 
goth86825081goth_
moths106021551moths
soths86218631soths
azoths18366202azoths
baths105922922baths
beths105519222beths
booths115313792booths
botas75328782botas
both96533432both_
bothy136713962bothy
bots66453952bot_s
botts75224862botts
broths115013922broths
cloths115512482cloths
cotes76347842cotes
cots68054842cot_s
couths115715412couths
dotes65836692dotes
doth86225712doth_
dots55647662dot_s
eths76619522_eths
froths125411442froths
garths104111502garths
gates65939512gates
gats56753442gat_s
getas65421482getas
gets55442482get_s
girths105612272girths
gites65630182gites
gits55744592git_s
goads77022852goads
goals65521292goals
goas55239942go_as
goats65527302goats
gobos86219382gobos
gobs76935572go_bs
gods65438042go_ds
goers65520252goers
goes55644092go_es
gogos77516522gogos
golds75421312golds
golfs95616102golfs
gongs74921612gongs
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912go_os
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gos47155132go__s
gosh86123422gosh_
got49870442got__
gotcha1234632gotcha
gotchas1334612gotchas
gothic1237792gothic
gothics1336122gothics
gouts64826172gouts
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
goxes135018262goxes
goys86328412go_ys
griths105211652griths
grots65025852grot_s
growths1494422growths
guts56637252gut_s
heths116317782heths
hots78349332hot_s
iotas54821112iotas
jotas125717442jotas
jots116336142jot_s
kiths125814972kiths
kophs145010932kophs
kotos95717702kotos
laths86022402laths
lochs106715512lochs
lotahs9479872lotahs
lotas55926302lotas
loth76132132loth_
lotos54724632lotos
lots47652092lot_s
lotus55718062lotus
maths105624022maths
meths105320232meths
months113812932months
motes75944002motes
moth96731332moth_
mothy136214552mothy
mots66853162mot_s
motts76527002motts
mouths115214532mouths
myths135911602myths
norths96812322norths
notes55034582notes
oaths86117312oaths
ohs66232312_o_hs
oohs75220692_oohs
oots46446442oot_s
paths105521382paths
piths105817542piths
poohs103915712poohs
pothos114214692pothos
pots66452362pot_s
qophs19507812qophs
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
rotos56027882rotos
rots46454092rot_s
rouths95416822rouths
rowths12458172rowths
ruths85714642ruths
sloths94911892sloths
sooths95715592sooths
sophs104916022sophs
soth75932522soth_
sots45552452sot_s
souths95216602souths
teths85418512teths
tooths96013802tooths
tophs105220052tophs
totes55139682totes
tots46654122tot_s
troths95414152troths
votes84627082votes
worths127812892worths
wots76342892wot_s
yodhs12669012yodhs
yoghs125410592yoghs
youths124510042youths

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001351.59333772.8
3Display Results1351350.0334090.9
 (SQL Overall)1786911351.93692299.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.