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

475 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
fritters11381078(None) 
critters103511311critters
fitters104517741f_itters
flitters114312171flitters
fretters113410301fretters
fritter103912771fritter_
gritters94210631gritters
ritters74020611_ritters
bitters94920352_bitters
chitters133711162chitters
critter94113032critter_
critturs10374592critturs
drifters12417912drifters
emitters10349642emitters
fainters11349692fainters
fetters103517902f_etters
filters103816542f_ilters
fitter94120032f_itter_
flatters113814202flatters
flirters11337932flirters
flitter103413902flitter_
flutters114010812flutters
fraters103517202fr_aters
fretter103412752fretter_
friers94718932fri__ers
frillers11349862frillers
friskers15337372friskers
frites94922482fri_te_s
fritted113611332fritte_d
frittered13205162frittered
fritterer12234402fritterer
fritterers13203392fritterers
fritts94613192fritt__s
fritzes19329452fritze_s
frizers19329552fri_zers
frizzers19335102frizzers
frothers14279802frothers
frotteurs1242212frotteurs
fruiters11328172fruiters
glitters93710542glitters
grifters12389232grifters
gristers94013402gristers
gritter83913352gritter_
hitters104717582_hitters
jitters144314462_jitters
knitters12336622knitters
litters73422562_litters
omitters10277652omitters
printers103214902printers
quitters17238522quitters
ratters74422472_ratters
rioters73615502_rioters
ritter63822412_ritter_
rotters74421392_rotters
sitters74221542_sitters
skitters12349542skitters
slitters84014132slitters
spitters104113382spitters
titters74219612_titters
trotters83310232trotters
twitters11296772twitters
whitters14359402whitters
writers105513492wri_ters
writhers14398982writhers
abetters1057173abetters
abutters1056983abutters
admitters1244553admitters
arbiters1038853arbiters
ariettes8411353ariette_s
baiters94619303bai_ters
batters94626013_batters
betters94422093_betters
bisters93922603_bisters
biters83925233_bi_ters
bitter84622673_bitter_
bittern94810683_bittern
bitterns10428943_bitterns
blatters104414093blatters
blisters104015083blisters
blithers134711233blithers
blitzers19417153blitzers
blotters104110983blotters
bribers114111493bri_bers
bridlers11359183bridlers
briefers1335143briefers
briers85319733bri__ers
brimmers14287073brimmers
briners94315633bri_ners
bringers112811073bringers
brittler10165983brittler_
brittles10178653brittles
britts84813443britt__s
brothers133410823brothers
bruiters10329133bruiters
butters94521713_butters
chatters134213933chatters
chitter124112963chitter_
citers85022973_ci_ters
cithers124315753_cithers
cittern9339133_cittern
citterns10318113_citterns
clatters103313903clatters
clutters103210343clutters
cointers103616403cointers
cotters94323433_cotters
crafters13419943crafters
craters95021883cr_aters
cribbers14306443cribbers
criers83918583cri__ers
crimmers14298543crimmers
crimpers14318933crimpers
cringers112511873cringers
crispers12309433crispers
crittur9315133crittur_
crofters13358893crofters
cutters94218953_cutters
dieters83216423_dieters
dithers114016153_dithers
dotters83715973_dotters
drafters12338523drafters
driers74516733dri__ers
drifter11348703drifter_
drillers9429713drillers
drinkers13277823drinkers
drippers13327933drippers
drivers114412793dri_vers
druthers1275793druthers
embitters13334723embitters
emitter93211083emitter_
erecters102611613erecters
fagoters1234853fagoters
fainter103611053fainter_
faitours1134253faitours
falters103916473f_alters
fathers133916503f_athers
fattens105111713f_attens
fatter94523213f_atter_
feasters11511563feasters
feathers143513243feathers
feigners1235483feigners
ferities111416713feritie_s
ferreters1246253ferreters
festers104121393f_esters
fetter94120383f_etter_
fibbers144510603f_ibbers
fibers114717523f_i_bers
fibsters13126403fibsters
fifers125414923f_i_fers
fighters15269393fighters
filers94623723f_i_lers
filisters1236993filisters
fillers104320203f_illers
filmers124211293f_ilmers
filter94517633f_ilter_
finders113717873f_inders
fingers113418433f_ingers
firers94922683f_i_rers
firmers124711443f_irmers
fishers134714723f_ishers
fitness10299393f_itness
fitted104716663f_itte_d
fittest102510803f_ittest
fivers124420923f_i_vers
fixers165112983f_i_xers
fizzers18357003f_izzers
flattens11357483flattens
flatter103815963flatter_
flattery14338293flattery
flichters1774173flichters
flickers17338883flickers
fliers94417193fli__ers
flinders12439263flinders
flingers123410193flingers
flippers15337993flippers
flirter10318673flirter_
flites95122443fli_te_s
flitted114011643flitte_d
flittered13196253flittered
flivvers1733113flivvers
floaters112711503floaters
flouters11419263flouters
flusters113811493flusters
fluters103713673f_luters
flutter104012093flutter_
fluttery14376143fluttery
flytiers14254483flytiers
footers104618333f_ooters
footlers113910793footlers
foresters12312533foresters
forgetters1444163forgetters
formatters1544563formatters
fosters104220093f_osters
fracturs13146303fracturs
frakturs15163253frakturs
framers125113823fr_amers
frankers15348353frankers
frater94520593fr_ater_
freers94717303fr__eers
freezers20307173freezers
freighters1764123freighters
fretless1138063fretless
fretted113411853frette_d
frettier1156593frettier_
friars93812093fri__ars
fribblers16314193fribblers
fridges12369483fridge_s
frier85225843fri__er_
fries85535603fri__e_s
friezes19418913frieze_s
frigates12310923frigate_s
friges104116483fri_ge_s
frightens1655393frightens
friller104111743friller_
fringes113514103fringe_s
frippery1832953frippery
frisbees13295013frisbees
frisees104411693fri_sees
frises94124273fri_se_s
frisettes1295353frisette_s
friseurs1133303friseurs
frisker14389273frisker_
friskets15326263friskets
friths124313583fri_t_hs
frits86129103fri_t__s
fritt86129413fritt___
frittata1142833frittata
frittatas1241833frittatas
frittering14105623frittering
fritting123510703fritting
frivolers1543473frivolers
frizer184011283fri_zer_
frizes184015463fri_ze_s
frizettes2193493frizette_s
frizzer18446893frizzer_
frizzes18338183frizze_s
frizzlers20293673frizzlers
fronter103611583fronter_
frontes104214163fronte_s
frontiers1254993frontiers
frosteds12305653frosteds
frother133110153frother_
frotteur1142503frotteur
frowners14377933frowners
fruiter10309683fruiter_
fruiterers1343003fruiterers
fruitier1136583fruitier_
fruitless1244163fruitless
fruitlets1243173fruitlets
fryers125710973fr__yers
furthers1436493furthers
fyttes1236933f_ytte_s
gaiters83516533gai_ters
garotters1055033garotters
getters84216093_getters
gittern8337503_gittern
gitterns9326563_gitterns
glisters93912603glisters
glitter84211803glitter_
glittery12375613glittery
goiters84014433goi_ters
grafters12409183grafters
granters93614133granters
graters85419733gr_aters
greeters92610113greeters
gridders11286293gridders
grievers1255473grievers
grifter113810493grifter_
grillers93810803grillers
grinders103410423grinders
grinners9288043grinners
gripers104011463gri_pers
grippers13358123grippers
grister83915413grister_
gritted94110903gritte_d
grittier9316263grittier_
grouters95910063grouters
grunters9359023grunters
gutters83715503_gutters
hatters104221523_hatters
heisters113413133heisters
hinters103719573_hinters
hitter94419863_hitter_
hoisters113513473hoisters
imbitters13274503imbitters
inters64328043__inters
jilters144211953_jilters
jitter133314993_jitter_
jittery17346443_jittery
jointers15289323jointers
jotters143413803_jotters
keisters123212043keisters
kilters113813593_kilters
kiters105218583_ki_ters
kittens11347583_kittens
klisters123910483klisters
knitter11348133knitter_
knotters12276143knotters
kraters114212333kr_aters
krimmers16315673krimmers
leisters83312823leisters
letters73819853_letters
lifters104313773_lifters
linters73822623_linters
listers74026523_listers
liters65429873_li_ters
litter64324853_litter_
littery103710493_littery
loiters74116613loi_ters
lotters73921063_lotters
matters94421753_matters
meisters103313843meisters
milters93619083_milters
minters93822463_minters
misters93927503_misters
miters84328773_mi_ters
mithers123516733_mithers
mittens9349883_mittens
mutters94117133_mutters
natters73718063_natters
netters73618583_netters
niters64624203_ni_ters
nutters74215423_nutters
omitter9298503omitter_
orbiters1036593orbiters
orienters937613orienters
otters64021513__otters
painters103013023painters
patters94825193_patters
peripters1368123peripters
permitters1444623permitters
petters93722363_petters
philters1398173philters
pitiers93812653_pitiers
platters103415283platters
plotters104011553plotters
pointers103013723pointers
potters94024343_potters
praters94921643pr_aters
prattlers11195323prattlers
presters103419003presters
pricers113915063pri_cers
prickers163710673prickers
priers84521193pri__ers
primers114215673pri_mers
prinkers143010383prinkers
printer93917303printer_
printery13318433printery
prizers183911843pri_zers
putters94219183_putters
quieters17248733quieters
quilters17228433quilters
quitter162910753quitter_
quittors17155413quittors
rafters103715633_rafters
ranters73323643_ranters
rasters74629023_rasters
raters63936573_r_aters
rattens74213403_rattens
ratter64326313_ratter_
rattlers83510293_rattlers
reinters82614773reinters
remitters11328403remitters
renters74224813_renters
resters74130403_resters
reutters8138563reutters
ribbers113913183_ribbers
ribiers9319753_ribiers
ricers84120993_ri_cers
ridders93612483_ridders
riders74123903_ri_ders
rievers104311453_rievers
riflers103512193_riflers
riggers93613833_riggers
righters122610703_righters
rimers84522553_ri_mers
rimmers113812883_rimmers
ringers83922953_ringers
rinsers73815743_rinsers
rioter64817283_rioter_
rippers114115023_rippers
risers64624783_ri_sers
riskers114011993_riskers
rites54442553_ri_te_s
ritzes154812943_ritze_s
rivers94626543_ri_vers
riveters11228153_riveters
roisters83615543roisters
rooters74522933_rooters
rosters73727533_rosters
rotter64325463_rotter_
rottes64524833_rotte_s
routers74822853_routers
scatters103612753scatters
scripters13116673scripters
scutters103311013scutters
setters73822063_setters
shatters113313903shatters
shifters14319853shifters
shutters113611333shutters
sifters103714783_sifters
sinters74024073_sinters
sisters73721573_sisters
sitter63323383_sitter_
skirters12337233skirters
skitter113810393skitter_
skittery15315103skittery
slithers114212953slithers
slitter73615873slitter_
slotters84012393slotters
smatters104011713smatters
smiters93414363smi_ters
smithers13369793smithers
snifters11318603snifters
spatters103914703spatters
spitter94015183spitter_
splitters11307323splitters
spotters104313373spotters
sprinters11329363sprinters
spritzers2043903spritzers
sputters104012863sputters
stinters83312743stinters
strutters955673strutters
stutters83210463stutters
suiters73618873sui_ters
swatters113911793swatters
swifters14277483swifters
swithers144310533swithers
swotters11448473swotters
tatters74520483_tatters
tetters74320473_tetters
tilters73315933_tilters
tinters74221103_tinters
titers64526403_ti_ters
titfers10318933_titfers
tithers104216733_tithers
titter63421163_titter_
totters74618733_totters
treaters83615823treaters
trickers143812813trickers
triers64321523tri__ers
triflers113110213triflers
triggers10257843triggers
trillers83613483trillers
trimers94615143tri_mers
trimeters1139203trimeters
trimmers12288913trimmers
trippers123210153trippers
triter65120593tri_ter_
trotter73312253trotter_
trusters83112243trusters
trysters11298363trysters
twisters11268173twisters
twitter10278093twitter_
twittery14303893twittery
uniters73814173uni_ters
ureters7311823ur_eters
utters63817113__utters
vetters104016313_vetters
waisters113811523waisters
waiters104218623wai_ters
wetters103817753_wetters
whetters14246653whetters
whitter139110893whitter_
whittlers1594333whittlers
winters103720473_winters
withers134417753_withers
wresters112711733wresters
wringers123110073wringers
writer94416513wri_ter_
writes94420333wri_te_s
writher134010853writher_
writhes134811703writhe_s
written10336343writte_n
yatters103914623_yatters
zithers193911973_zithers

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461624757.75018859.6
3Display Results4754750.1702794.1
 (SQL Overall)1786914758.09322079.7
 
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.