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

285 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
goats6552730(None) 
boats75635151boats
coats75634991coats
doats65224881doats
gats56753441g_ats
ghats95818611ghats
gloats74515421gloats
gnats65217711gnats
goads77022851goads
goals65521291goals
goas55239941goa_s
goat56250831goat_
gouts64826171gouts
groats74816651groats
moats75827641moats
oats46554211_oats
bats66962332_bats
beats76042242beats
blats75132502blats
bloats85215762bloats
boars75229602boars
boarts84716872boarts
boas66150832boa_s
boast75935702boast
boasts85017922boasts
boat66360312boat_
bolts76232112bolts
boots75837972boots
borts76735452borts
botas75328782botas
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
brats75336012brats
cats66356342_cats
chats105730092chats
coacts105314322coacts
coals76129602coals
coapts104614002coapts
coast75236262coast
coasts85719132coasts
coat67558342coat_
coati75624632coati
coatis85122592coatis
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
doat56947672doat_
doits66223672doits
dolts65626312dolts
dots55647662do_ts
drats66628372drats
eats47054872_eats
fats76252502_fats
feats86432752feats
fiats85324482fiats
flats86429742flats
floats96816252floats
foals85721692foals
foams105017952foams
fonts86124752fonts
foots85528282foots
forts86034452forts
frats86829672frats
gabs76740422g_abs
gads67843382g_ads
gaes56348032g_aes
gags66441062g_ags
gaits65726012gaits
gals57946502g_als
gams76648882g_ams
gaols66717572gaols
gaps76042972g_aps
gars55750742g_ars
gas48870252g_a_s
gast56052562g_ast
gasts66628632gasts
gat46880512g_at_
gate55746572g_ate
gates65939502g_ates
gays87338022g_ays
gears64628692gears
gelts65924612gelts
gents65729612gents
gests66028812gests
getas65421482getas
gets55442482g_ets
ghast95621222ghast
ghat86435282ghat_
ghauts10447782ghauts
ghosts10489272ghosts
giants74713502giants
gifts96214962gifts
gilts64924262gilts
girts65423622girts
gists66026192gists
gits55744592g_its
glads75620612glads
glams85822932glams
glans65125832glans
glass65518132glass
gloams95210662gloams
gloat65427682gloat_
glosts74513812glosts
glouts74414712glouts
gluts66120132gluts
gnars66718852gnars
gnat56034432gnat_
gnaws96311142gnaws
goa47343802goa__
goad66830982goa_d
goal55829302goa_l
goatee73219532goatee
goatees82710432goatees
goatish1139562goatish
gobans94412042gobans
gobos86219372gobos
gobs76935572go_bs
godets8410932godets
gods65438042go_ds
goers65520252goers
goes55644092go_es
gogos77516522gogos
golds75421312golds
golfs95616102golfs
gonads84511732gonads
gongs74921612gongs
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912go_os
gorals76917652gorals
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gos47155132go__s
got49870442go_t_
goth86825082go_th
goths96513002goths
gout56646002gout_
gouty95217362gouty
gowans105512292gowans
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
goxes135018262goxes
goys86328412go_ys
grabs85719692grabs
grads75625752grads
grafts105013252grafts
grams85327312grams
grans64832542grans
grants73722472grants
grass66125202grass
grat55651282grat_
grate64932882grate
grates75429882grates
gratis74819242gratis
grays95621332grays
greats76318392greats
grits65529582grits
groans74815062groans
groat65531972groat_
grots65025852grots
grouts75015612grouts
guans64419442guans
guars65021042guars
gusts65722792gusts
guts56637252g_uts
hats76858252_hats
heats85838402heats
hoars85925542hoars
holts85627912holts
hoots84830242hoots
hosts85526702hosts
hots78349322ho_ts
ikats95311152ikats
iotas54821112iotas
jolts125018882jolts
jotas125717442jotas
jots116336142jo_ts
kats85944332_kats
khats125316012khats
koans95818622koans
koas85635092koa_s
korats105416062korats
kyats125012442kyats
lats45962702_lats
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
loath84918602loath
lofts85518362lofts
loots55431422loots
lotas55926302lotas
lots47652092lo_ts
louts56330272louts
lovats939072lovats
mats65460282_mats
meats75034052meats
moans74624362moans
moas65545342moa_s
moat66352032moat_
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
neats55931902neats
nowts86915852nowts
oafs76425262_oafs
oaks86527902_oaks
oars46846032_oars
oast47156322_oast
oasts56529182_oasts
oat39888262_oat_
oath76132152_oath
oaths86117312_oaths
ogams84112682ogams
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
pats66460852_pats
peats76140192peats
plats75531372plats
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
pouts75530322pouts
prats76333392prats
qats135331342_qats
rats46260372_rats
roads66523612roads
roams74919612roams
roans54926442roans
roars55622232roars
roast56230142roast
roasts64915412roasts
roots55933672roots
rotas54827722rotas
rots46454092ro_ts
routs57133412routs
scats75930602scats
seats54844342seats
shoats94117072shoats
skats94621532skats
slats55436902slats
soaks95220292soaks
soaps75120712soaps
soars54732512soars
softs85019232softs
soots55536202soots
sorts54536662sorts
sots45552442so_ts
spats75031382spats
stats55933362stats
stoats65117482stoats
swats85726862swats
tats46858132_tats
teats55636812teats
toads65621062toads
toast55831012toast
toasts65914992toasts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
twats86616602twats
vats76841742_vats
volts85421292volts
wats77555882_wats
whats117718992whats
woads94818442woads
wonts87621542wonts
worts88631182worts
wots76342892wo_ts

Search took 3 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.0931921408.6
2DLD Change Limit538002851.86028924.7
3Display Results2852850.0763750.0
 (SQL Overall)1786912852.02988068.5
 
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.