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

215 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
gists6602619(None) 
agists75713171agists
cists76624531cists
fists85527541fists
gasts66628631gasts
gests66028811gests
gifts96214961gifts
gilts64924261gilts
girts65423621girts
gist56046761gist_
gits55744591gi_ts
grists74716481grists
gusts65722791gusts
hists86328371hists
kists95822111kists
lists56628691lists
mists76633901mists
wists86728521wists
ageists848492ageists
agisms9399392agisms
agist66325582agist_
airts55626342airts
aits46355532ai_ts
basts75936932basts
bests75932612bests
bints76130182bints
bises75435622bises
bisks115416802bisks
bits66148162bi_ts
bitts75022592bitts
busts75227692busts
casts77237792casts
cist67244962cist_
cistus84611342cistus
costs77231142costs
cysts105912772cysts
deists74916432deists
diets66026642diets
dints67431312dints
dirts66824462dirts
discs85316262discs
disks105417472disks
diss56434482dis_s
dits56450522di_ts
dusts65923562dusts
easts57530322easts
egests74411252egests
egises7312492egises
egoists887072egoists
exists134710912exists
fasts86429682fasts
feists94915312feists
fests85828042fests
fiats85324482fiats
firsts95110922firsts
fiscs105311882fiscs
fist76248422fist_
fits76043462fi_ts
foists95413982foists
gaits65726012gaits
gases65633992gases
gasps85415482gasps
gast56052562gast_
gats56753442g_ats
geests75912162geests
gelts65924612gelts
gents65729612gents
gest56149132gest_
geste65920692geste
gestes75721392gestes
gets55442482g_ets
ghats95818612ghats
ghosts10489272ghosts
giants74713502giants
gibes84422522gibes
gibs75529272gi_bs
gids65933742gi_ds
gies55641422gi_es
gift86735792gift_
gigas75415582gigas
gigots83911952gigots
gigs66631182gi_gs
gilds75417522gilds
gills64728192gills
gilt56348542gilt_
gimps105915202gimps
ginks104319562ginks
gins55543952gi_ns
gips75632922gi_ps
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girt56646422girt_
girth95618842girth
girths105612272girths
gismo848862gismo
gismos957182gismos
git46266052gi_t_
gite55438612gi_te
gites65630182gites
gives95324872gives
glints75714212glints
glosts74513812glosts
gluts66120132gluts
gnats65217712gnats
goats65527302goats
gouts64826172gouts
grifts104511682grifts
griots74713642griots
grist65529872grist_
grits65529582grits
grots65025852grots
guests74311202guests
guilts74111232guilts
guises74216312guises
gust55240702gust_
gusto65414642gusto
gusty95119572gusty
guts56637252g_uts
heists96814632heists
hests85829932hests
hilts86924412hilts
hints87330622hints
hiss75629212his_s
hist76551542hist_
hits75545132hi_ts
hoists95516022hoists
hosts85526702hosts
isms66213472_isms
its35538832_i_ts
jests125922452jests
jilts124717412jilts
jisms14458002jisms
joists134711032joists
justs124918262justs
kilts95122182kilts
kiss85227402kis_s
kist86540802kist_
kits86441772ki_ts
lasts57731262lasts
legists899592legists
lifts85719062lifts
lilts55822802lilts
lints57137192lints
lisps76913912lisps
list47055342list_
lits46252492li_ts
lusts55022802lusts
maists85817572maists
masts77035762masts
midsts95510052midsts
milts75430712milts
mints76834042mints
mises74740562mises
misos76523292misos
miss65339422mis_s
mist66154532mist_
misty106120452misty
mitts75523752mitts
mosts76028542mosts
musts75527442musts
nests55728002nests
nisus56014392nisus
nits45741642ni_ts
oasts56529182oasts
odists749852odists
ousts55225702ousts
pasts75936502pasts
pests75933272pests
pints75936222pints
pisos76021062pisos
piss65033332pis_s
piste75824602piste
pistes85325632pistes
pits66348742pi_ts
posts75228782posts
rests54935872rests
rifts85718642rifts
riots54922012riots
rises55244042rises
risks94917062risks
risus54216392risus
rusts55026992rusts
shists96515112shists
sifts84918922sifts
silts55330822silts
sises55233832sises
sits45050202si_ts
tests56530192tests
tilts55325612tilts
tints56030922tints
tits46145042ti_ts
twists9549752twists
vasts86423772vasts
vests85325982vests
visas84317652visas
vises84427772vises
visits9311422visits
vista85416602vista
vistas94513272vistas
waists97415452waists
wasts87433672wasts
wests85727002wests
whists124613812whists
wilts85023502wilts
wises85633192wises
wisps105214182wisps
wiss75630542wis_s
wist78049292wist_
wits76044872wi_ts
wrists95415642wrists
xysts15558122xysts
zests145419742zests
zits136030292zi_ts

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.313570897.8
2DLD Change Limit538002151.57634137.1
3Display Results2152150.0633412.7
 (SQL Overall)1786912151.95291542.5
 
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.