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 “fifties” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

438 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
fifties13211108(None) 
nifties102612501nifties
biffies152710852biffies
cities84524852ci_ties
dirties83119382dirties
ditties83116982ditties
fatties103018202fatties
fifes114822392fif__es
fifteen1343922fifteen
fifteens1442752fifteens
fifths15406542fift_hs
fiftieth1742582fiftieth
fiftieths1851562fiftieths
fillies103420252fillies
finites10315922finites
fixities1838212fixities
footies103721542footies
forties104323862forties
giftees11306512giftees
jiffies20327472jiffies
kilties113014142kilties
kitties113213622kitties
lefties10312072lefties
niftier10328712niftier
niftiest112910062niftiest
pieties9419222pieties
pities83828082pi_ties
sixties14310972sixties
softies103414612softies
titties73617362titties
wiftier13297732wiftier
wiftiest14279172wiftiest
airtimes1037503airtimes
amities9317383amities
aunties73920073aunties
baffies153612943baffies
banties94324763banties
bawties124214313bawties
bhisties1339003bhisties
bialies93618413bialies
biddies113514493biddies
bifaces1448063bifaces
biffins15358533biffins
biggies113813523biggies
bikies124515163bi_kies
bilbies114712333bilbies
billies93923503billies
biotics113812173biotics
biotins93114453biotins
biotites10310083biotites
birdies104016213birdies
birkies133712433birkies
bistres94017213bistres
bites75641173bi_t_es
bittier94211663bittier
bittiest103012043bittiest
booties94124613booties
butties93217953butties
catties94023053catties
chitties13310773chitties
cissies94116153cissies
cites74435583ci_t_es
citied94014143ci_tied
civies114116443ci_vies
civvies1555843civvies
cooties93725733cooties
cuties84927363_cuties
cutties93118843cutties
dainties9312403dainties
dauties83315763dauties
dawties113312703dawties
defies104624053def_ies
deifies113317453deif_ies
deities82621923deities
diaries83321953diaries
dickies143416343dickies
dictier103411863dictier
dictiest113212783dictiest
didies84621833di_dies
dillies84122153dillies
dimities11314003dimities
dingies93618243dingies
dinkies123716033dinkies
dirtied93210853dirtied
dirtier83312093dirtier
dirtiest93014203dirtiest
distils83015803distils
dites66339153di_t_es
ditzes163212423di_tzes
divvies1457663divvies
dizzies16279753dizzies
driftier1275123driftier
driftiest1335943driftiest
duties74921903_duties
edifies113012283edif_ies
effigies1543513effigies
eighties12710803eighties
empties11712243empties
facies113921593f_acies
faeries104118993faeries
fairies103516043fairies
falsies103515013falsies
fancies124018783fancies
fannies103415643fannies
farcies125317883farcies
fates85139233f_at_es
fattier103513463fattier
fattiest113514313fattiest
fealties1139993fealties
feistier1136193feistier
feistiest1237073feistiest
fellies104119743fellies
ferities111416713ferities
ferlies103216693ferlies
ferries103521083ferries
fetes85630143f_et_es
fettles103912733fettles
fiacres1237253fiacres
fiances12310673fiances
fiats85324483fiat__s
fibres114312123fi_bres
fibrils1236843fibrils
fibrins1238633fibrins
fices106031163fi__ces
fiches145219533fi_ches
ficins113513983fi_cins
ficoes114613463fi_coes
fictile1238023fictile
fiction122010733fiction
fictions132410743fictions
fictive1537023fictive
ficuses12159203ficuses
fiddles123212603fiddles
fidges114114383fi_dges
fierier103511193fierier
fieriest112112243fieriest
fife106027703fif__e_
fifed125115973fif__ed
fifer115519973fif__er
fifers125414923fif_ers
fifing134212343fif_ing
fifth145210923fift__h
fifthly1943093fifthly
fifty145211423fift__y
fiftyish2042553fiftyish
figures11239103figures
filches153410723filches
files85441273fi__les
filles94224523fi_lles
fillips12298133fillips
filmier1237503filmier
filmiest1338553filmiest
filmis114610283filmi_s
filter94517633filt_er
filters103816543filters
filthier1434073filthier
filthiest1545373filthiest
filths12389783filt_hs
fimbles143510653fimbles
finales104016013finales
finches153914193finches
fineries112416743fineries
fines86644263fi__nes
finis86824263fi_ni_s
finises10312903finises
finite9316823finite_
finnier10319943finnier
finniest113011403finniest
fipples14298653fipples
fiques1837973fi_ques
fireflies1545353fireflies
fires85740753fi__res
firkins1437663firkins
firrier103410123firrier
firriest112310433firriest
firths125113503firt_hs
fishes125221343fi_shes
fishier13359853fishier
fishiest14310453fishiest
fisted104218703fist_ed
fistic11812573fisti_c
fisting113818123fisting
fists85527543fist__s
fitches153516193fitches
fitness10299393fi_tness
fits76043463fi_t__s
fitted104716663fi_tted
fitter94120033fi_tter
fitters104517743fitters
fittest102510803fi_ttest
fitting113516563fitting
fittings12318203fittings
fives116027363fi__ves
fixates1737383fixates
fixatifs2162073fixatifs
fixatives2243353fixatives
fixes154723593fi__xes
fixtures1835283fixtures
fixures17596063fixures
fizgigs2142203fizgigs
fizzes174512553fi_zzes
fizzier18326713fizzier
fizziest19226073fizziest
fizzles18339063fizzles
flies85630713__flies
flimsies1335783flimsies
flintier1136393flintier
flintiest1248433flintiest
flirtier1144883flirtier
flirtiest1236183flirtiest
flites95122443flit_es
flutes95421783flut_es
flutier103011553flutier
flutiest112610883flutiest
flytes123911563flyt_es
flytier13356503flytier
flytiers14254483flytiers
fogies104118063f_ogies
folkies143612253folkies
follies103618943follies
fomites123613203fomites
foodies113416753foodies
footie94718133footie_
footier104115103footier
footiest113514913footiest
footles103715713footles
footsies1139643footsies
fortes95327183fort_es
fortis95418613forti_s
frailties1245853frailties
friaries11310083friaries
fries85535603__fries
frites94922483frit_es
fritzes19329453fritzes
frizzies19315933frizzies
fuddies123211203fuddies
funnies104113603funnies
furies95126373f_uries
fustics1279593fustics
fustier104213933fustier
fustiest113014573fustiest
futzes184313113f_utzes
fyttes1236933f_yttes
gaieties9310183gaieties
giddies103713363giddies
gifted114510703gift_ed
giftee103512083gift_ee
gifting123810893gifting
giftless1245173giftless
gifts96214963gift__s
gillies84120963gillies
gimmies123010103gimmies
gipsies1039903gipsies
girlies83013703girlies
gites65630183gi_t_es
heftier1337203heftier
heftiest1439183heftiest
hickies163614743hickies
hinnies103615103hinnies
hippies142813743hippies
hissies103915823hissies
hogties112813993hogties
hotties103016953hotties
iffier1236753_iffier
iffiest1337953_iffiest
immies102412423_immies
indies73822773_indies
intines7921113_intines
intis55121633_inti_s
istles62814983_istles
ivies84215753_i_vies
ixtles13217063_ixtles
jetties143613123jetties
jimmies18328773jimmies
jutties143814003jutties
kiddies133412283kiddies
killies113318113killies
kiltie103210963kiltie_
kirtles11309663kirtles
kites95432543ki_t_es
kithes135016653ki_thes
kittles113012493kittles
laities7320343laities
lifetimes1444153lifetimes
lifted104413523lift_ed
lifter93814813lift_er
lifters104313773lifters
lifting113313273lifting
liftmen1234233liftmen
lifts85719063lift__s
lilies63021413li_lies
limites92915453limites
lindies8416583lindies
lintier73613793lintier
lintiest82715913lintiest
listees73416673listees
litres65220393li_tres
littles73212783littles
loftier1037763loftier
loftiest1139083loftiest
maftirs1236043maftirs
middies113116153middies
miffier1537023miffier
miffiest1637123miffiest
miltier93214963miltier
miltiest103015173miltiest
minnies93617363minnies
mintier93615993mintier
mintiest103217143mintiest
miotics112710653miotics
mislies92922283mislies
missies93423983missies
mistier93418713mistier
mistiest103018313mistiest
mistimes12612613mistimes
mites75141803mi_t_es
mitier83620663mi_tier
mitiest93520053mi_tiest
mitis75425983mi_ti_s
mitises9315543mi_tises
mitres83922073mi_tres
moieties10311263moieties
muftis1158053mufti_s
nasties73520493nasties
niceties10310863niceties
niftily1335753niftily
niftiness1236363niftiness
nighties121011383nighties
nineties8312913nineties
ninnies73713613ninnies
nites55736343ni_t_es
nitres65519333ni_tres
nittier73512243nittier
nittiest82712603nittiest
nixies135313873ni_xies
panties94230933panties
parties93230863parties
pasties94529813pasties
patties93425143patties
piffles15368763piffles
piggies113813483piggies
pigmies122610993pigmies
pigsties1139783pigsties
pinites9319533pinites
pinkies133818263pinkies
pinnies93318443pinnies
pintles94118723pintles
pintoes95117713pintoes
pistes85325633pist_es
pistils93314303pistils
pitied94017253pi_tied
pitier84019823pi_tier
pitiers93812653pi_tiers
pixies154915513pi_xies
platies93722543platies
posties93128813posties
potties93723543potties
punties94520783punties
putties94420023putties
reflies104418533reflies
refries104419733refries
reifies104218283reif_ies
reties65436193_reties
riffles133911163riffles
rifles94217703rif_les
riflips1234163riflips
rifted104115313rift_ed
rifting113515003rifting
riftless1136943riftless
rifts85718643rift__s
righties12711573righties
riptides1136403riptides
rites54442553ri_t_es
ritzes154812943ri_tzes
safeties1139163safeties
salties73725773salties
shiftier1436333shiftier
shiftiest1537353shiftiest
sickies133717503sickies
sifted104313673sift_ed
sifter94516233sift_er
sifters103714783sifters
sifting113014593sifting
siftings12236583siftings
sifts84918923sift__s
silkies113715693silkies
sillies73425073sillies
siltier73413863siltier
siltiest83515613siltiest
sissies73716603sissies
sites56045433si_t_es
sixtes133612403sixt_es
softie93312473softie_
sorties74126403sorties
spiffies16277983spiffies
sties55132983__sties
stiffies14258373stiffies
taffies133012693taffies
tatties74120343tatties
thirties1139723thirties
tidies74721833ti_dies
ties45248313___ties
tiffins13327983tiffins
tiptoes939173tiptoes
tithes94720213ti_thes
titis56023813ti_ti_s
titles63719923ti_tles
titres64718933ti_tres
tittie63213153tittie_
tittles73413253tittles
tizzies15287893tizzies
toffies133210213toffies
tuftier1096603tuftier
tuftiest1138273tuftiest
tutties73216473tutties
ubieties1046913ubieties
unifies102714713unif_ies
unities72520143unities
unties64326923_unties
vichies15310623vichies
victims1436003victims
virtues10338023virtues
vittles103211113vittles
waffies163611443waffies
whities133113253whities
widdies123514033widdies
wienies102213683wienies
wifes114522563wif__es
willies103920153willies
wintles103414983wintles
wites85536963wi_t_es
withes124620843wi_thes
withies133913543withies
wittier103910823wittier
wittiest112711523wittiest
yippies14279293yippies
zitis145815583zi_ti_s
zloties1639913zloties

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274386.54620474.6
3Display Results4384380.1702576.5
 (SQL Overall)1786914386.87226002.8
 
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.