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

227 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
fists8552754(None) 
cists76624531cists
fasts86429681fasts
feists94915311feists
fests85828041fests
fiats85324481fiats
firsts95110921firsts
fiscs105311881fiscs
fist76248421fist_
fits76043461fi_ts
foists95413981foists
gists66026191gists
hists86328371hists
kists95822111kists
lists56628691lists
mists76633901mists
wists86728521wists
agists75713172agists
airts55626342airts
aits46355532ai_ts
basts75936932basts
bests75932612bests
bints76130182bints
bises75435622bises
bisks115416802bisks
bits66148152bi_ts
bitts75022592bitts
busts75227692busts
casts77237792casts
cist67244962cist_
cistus84611342cistus
costs77231142costs
cysts105912772cysts
deists74916432deists
diets66026642diets
dints67431312dints
dirts66824462dirts
discs85316262discs
disks105417472disks
diss56434482dis_s
dits56450522di_ts
dusts65923562dusts
easts57530322easts
exists134710912exists
facts107021892facts
faints94818782faints
farts88336842farts
fast77052312fast_
fats76252502f_ats
feasts95116092feasts
feats86432752feats
feints94813872feints
feist86230072feist_
feisty12449292feisty
felts85324542felts
fess76529162fes_s
fest74949442fest_
fets75345942f_ets
fiars86720832fiars
fiat76646642fiat_
fibs96329492fi_bs
fices106031162fices
ficus105015492ficus
fidos95819052fidos
fids87034732fi_ds
fiefs116213702fiefs
fiesta938122fiesta
fiestas1038432fiestas
fifes114822392fifes
fifth145210922fifth
fifths15406542fifths
fifty145211422fifty
fights133816552fights
figs85332642fi_gs
files85441272files
filets94718952filets
fills84632372fills
films105617962films
filos86125382filos
fils75838692fi_ls
filth115015822filth
filths12389782filths
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fi_ns
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fi_rs
first86226122first_
firth115819532firth
firths125113502firths
fisc96819752fis_c
fish106926272fis_h
fishes125221342fishes
fishy146011662fishy
fisted104218702fisted
fistic11812572fistic
fit66365452fi_t_
fives116027362fives
fixes154723592fixes
fixt1410729712fixt_
flats86429742flats
flints95617452flints
flirts95411482flirts
flits85625222flits
foist85730972foist_
fonts86124752fonts
foots85528282foots
forts86034452forts
foss76431642fos_s
frats86829672frats
frets85523402frets
frises94124272frises
frisks13479262frisks
frits86129102frits
fritts94613192fritts
frosts94214622frosts
fuses85628422fuses
fuss76027932fus_s
fusty115016512fusty
gasts66628632gasts
gests66028812gests
gifts96214962gifts
gilts64924262gilts
girts65423622girts
gist56046762gist_
gits55744592gi_ts
grists74716482grists
gusts65722792gusts
heists96814632heists
hests85829932hests
hilts86924412hilts
hints87330622hints
hiss75629212his_s
hist76551542hist_
hits75545132hi_ts
hoists95516022hoists
hosts85526702hosts
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
shists96515102shists
sifts84918922sifts
silts55330822silts
sises55233832sises
sits45050202si_ts
tests56530192tests
tilts55325612tilts
tints56030922tints
tits46145032ti_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 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.1061685764.2
2DLD Change Limit538002271.98627089.6
3Display Results2272270.0633603.2
 (SQL Overall)1786912272.15582919.3
 
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.