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

219 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
hists8632837(None) 
cists76624531cists
fists85527541fists
gists66026191gists
heists96814631heists
hests85829931hests
hilts86924411hilts
hints87330621hints
hiss75629211his_s
hist76551541hist_
hits75545131hi_ts
hoists95516021hoists
hosts85526701hosts
kists95822111kists
lists56628691lists
mists76633901mists
shists96515101shists
whists124613811whists
wists86728521wists
agists75713172agists
airts55626342airts
aits46355532ai_ts
basts75936932basts
bests75932612bests
bints76130182bints
bises75435622bises
bisks115416802bisks
bits66148152bi_ts
bitts75022592bitts
busts75227692busts
casts77237792casts
chests114916262chests
chints115117832chints
chits105424572chi_ts
cist67244962cist_
cistus84611342cistus
costs77231142costs
cysts105912772cysts
deists74916432deists
diets66026642diets
dints67431312dints
dirts66824462dirts
discs85316262discs
disks105417472disks
diss56434482dis_s
dits56450522di_ts
dusts65923562dusts
easts57530322easts
exists134710912exists
fasts86429682fasts
feists94915312feists
fests85828042fests
fiats85324482fiats
firsts95110922firsts
fiscs105311882fiscs
fist76248422fist_
fits76043462fi_ts
foists95413982foists
gasts66628632gasts
gests66028812gests
ghosts10489272ghosts
gifts96214962gifts
gilts64924262gilts
girts65423622girts
gist56046762gist_
gits55744592gi_ts
grists74716482grists
gusts65722792gusts
haets86525122haets
hafts116219462hafts
haints94417582haints
halts85230102halts
hants86335402hants
harts88441592harts
hasps105114642hasps
hast76259482hast_
haste85927862haste
hastes95727072hastes
hasty115718762hasty
hats76858252h_ats
heats85838402heats
hefts116218152hefts
heist87030912heist_
hents87330742hents
hest75950772hest_
hets75547202h_ets
hiatus938222hiatus
hicks145322172hicks
hides95129422hides
hies74842832hi_es
highs125412522highs
hights133716892hights
hikes125426982hikes
hills85431352hills
hilt75850712hilt_
hilus84817642hilus
hims95230972hi_ms
hinds96721472hinds
hins76447992hi_ns
hint77455742hint_
hips96433702hi_ps
hires86134342hires
his66359502hi__s
hisn79620932his_n
hisses94719352hisses
hissy116112122hissy
histed104420242histed
hit66569192hi_t_
hives116925512hives
hoises94823672hoises
hoist86433212hoist_
holists104413962holists
holts85627912holts
hoots84830242hoots
horsts95817512horsts
hoses85443172hoses
host77852832host_
hosta85917832hosta
hostas94515822hostas
hots78349322h_ots
hunts86826172hunts
hursts97213092hursts
hurts86922822hurts
husks125015452husks
huts76737442h_uts
isms66213472_isms
its35538832_i_ts
jests125922452jests
jilts124717412jilts
jisms14458002jisms
joists134711032joists
justs124918262justs
kilts95122182kilts
kiss85227392kis_s
kist86540792kist_
kits86441762ki_ts
lasts57731262lasts
lifts85719062lifts
lilts55822802lilts
lints57137192lints
lisps76913902lisps
list47055342list_
lits46252492li_ts
lusts55022802lusts
maists85817572maists
masts77035762masts
midsts95510052midsts
milts75430712milts
mints76834042mints
mises74740562mises
misos76523292misos
miss65339412mis_s
mist66154522mist_
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
schists1248542schists
shifts124412932shifts
shirts94918332shirts
shist84829602shist_
shits84731162shi_ts
sifts84918922sifts
silts55330822silts
sises55233832sises
sits45050202si_ts
tests56530192tests
theists1039142theists
thirsts1036242thirsts
tilts55325612tilts
tints56030922tints
tits46145032ti_ts
twists9549752twists
vasts86423772vasts
vests85325982vests
visas84317652visas
vises84427772vises
visits9311422visits
vista85416602vista
vistas94513272vistas
waists97415452waists
wasts87433672wasts
wests85727002wests
whishts16425312whishts
whisks16497352whisks
whist115322952whist_
whits115923822whi_ts
wilts85023502wilts
wises85633192wises
wisps105214182wisps
wiss75630542wis_s
wist78049292wist_
wits76044872wi_ts
wrists95415642wrists
xysts15558122xysts
zests145419742zests
zits136030292zi_ts

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 Filter178691538000.280638182.1
2DLD Change Limit538002193.34316093.3
3Display Results2192190.0932354.8
 (SQL Overall)1786912193.71648086.9
 
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.