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

226 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
snoozers1729693(None) 
snookers12398641snookers
snoopers10319831snoopers
snoozer16409181snoozer_
snoozes16289761snooze_s
boozers183912442_boozers
doozers17419292_doozers
noosers74913902_noosers
scoopers124210192scoopers
scooters103511012scooters
shooters112811552shooters
sneezers17246142sneezers
snooker113910302snooker_
snooper93511532snooper_
snooze15439982snooze__
snoozed173410122snooze_d
snoozier17185182snoozier_
snoozles17335562snoozles
snorers74313792sn_orers
snorters83410562snorters
sooners73916642s_ooners
spoofers13307322spoofers
spoolers10349362spoolers
stookers12449792stookers
stoopers103711292stoopers
swooners11336862swooners
swoopers13317522swoopers
annoyers1185033annoyers
bloomers12348823bloomers
bloopers12397373bloopers
boogers104514633_boogers
bookers134016613_bookers
boomers114115913_boomers
boozer174815963_boozer_
boozes174916523_booze_s
bronzers19296983bronzers
brooders112610233brooders
choosers134810863choosers
cooers84324563_coo_ers
cookers134619463_cookers
coolers93522493_coolers
coopers114019483_coopers
cooters94525713_cooters
crooners103911393crooners
crozers184111083_crozers
doozer163910463_doozer_
dozers164815423__dozers
encoders1137513encoders
endowers1238233endowers
enjoyers1843883enjoyers
enrobers10236943enrobers
flooders12257833flooders
floorers11227573floorers
footers104618333_footers
foozlers20346073_foozlers
goobers10219613_goobers
groomers11388483groomers
groovers12337123groovers
honorers1139263honorers
hoofers134513323_hoofers
hookers144916513_hookers
hoopers123616483_hoopers
hooters104520463_hooters
hoovers134312703_hoovers
incomers1268583incomers
intoners889913intoners
invokers1534663invokers
ionizers17257713ionizers
ionomers1038503ionomers
knockers13285733knockers
knollers12255133knollers
knotters12276143knotters
knowers1436333kn_owers
lookers114014073_lookers
loopers93914033_loopers
looters74419163_looters
momzers20367133_momzers
monomers12311033monomers
mooners94015343_mooners
mooters93818623_mooters
nodders94410253_nodders
nonzero1646093_nonzero
nooser65517823_nooser_
nooses65623643_noose_s
noshers103614323_noshers
noters64020993_n_oters
onlookers1343103onlookers
oozes145418713__ooze_s
poolers94217423_poolers
potzers184010543_potzers
proofers13118363proofers
roofers105013903_roofers
roomers95416413_roomers
roosers74217873_roosers
rooters74522933_rooters
rozzers1535633_rozzers
savorers1157223savorers
schmoozers26223253schmoozers
schooners1445653schooners
scoffers16286133scoffers
scolders11288993scolders
scooper113812033scooper_
scooter93312863scooter_
scorers94115313s_corers
scorners10228493scorners
scoters93313793s_coters
scourers10348533scourers
scouters103411303scouters
scowders14276213scowders
scowlers13257343scowlers
seizers164112503s_eizers
seltzers1735063seltzers
shmoozes22254863shmooze_s
shnorrers1243533shnorrers
shockers17319463shockers
shoers94518323s_ho_ers
shooter103013973shooter_
shoppers153010753shoppers
shouters113510593shouters
shovers134612993s_hovers
showers134612663s_howers
sizers155215813s__izers
slobbers12398523slobbers
sloggers10418783sloggers
slopers94213093s_lopers
slotters84012393slotters
smokers13389323s_mokers
smolders11287193smolders
smoochers16184833smoochers
smoothers14206043smoothers
smothers13349933smothers
snackers143010223snackers
snappers123510163snappers
snarers74216663sn_arers
snarlers8298753snarlers
sneakers12308643sneakers
sneerers8309803sneerers
sneers64016173sn__eers
sneezer16237963sneezer_
sneezes16278503sneeze_s
snickers143010963snickers
sniffers14257123sniffers
snifters11318603snifters
sniggers10317093sniggers
snipers93311763sn_ipers
snippers12299713snippers
snobbery15514283snobbery
snooded94110363snoode_d
snoods74312443snoo__ds
snooked123711493snooke_d
snookered1443263snookered
snooks104412823snoo__ks
snooled84513933snoole_d
snools65715873snoo__ls
snooped103711813snoope_d
snoopier10177273snoopier_
snoops84314163snoo__ps
snooted84213273snoote_d
snootier8278373snootier_
snoots64216663snoo__ts
snooziest18175383snooziest
snoozing18319073snoozing
snoozle16305903snooz_le
snoozled18344493snoozled
snoozy18517223snooz__y
snorer64316763sn_orer_
snores64324313sn_ore_s
snorkels1234413snorkels
snorter74412653snorter_
snowier1038783snowier_
snowless1145613snowless
snubbers12326673snubbers
snuffers14326913snuffers
soakers114114953s_oakers
soapers93715923s_oapers
soarers74118093s_oarers
sobbers114114253s_obbers
sobers85218853s__obers
soccers1138393s_occers
solders83517773s_olders
solvers104414253s_olvers
sonders83820713s_onders
sooner64220463s_ooner_
soothers113913433soothers
sorners73416863s_orners
sorters74221113s_orters
souters74422583s_outers
sowers94923433s__owers
spoilers10238633spoilers
spongers1137603spongers
spoofer12368723spoofer_
spoofery16354313spoofery
spookery17264143spookery
spooler93711383spooler_
spooneys13314583spooneys
spoors84014023spoo__rs
sporters103714053sporters
spotters104313373spotters
spouters104011143spouters
stockers143411073stockers
stokers114515183s_tokers
stompers123610033stompers
stoners74817953s_toners
stooges83611483stooge_s
stooker113811733stooker_
stooper93813183stooper_
stopers94217363s_topers
stopovers1443833stopovers
stoppers123910573stoppers
storers75018683s_torers
stovers103713733s_tovers
strokers123910893strokers
stroyers11388913stroyers
swobbers15355593swobbers
swooner10358673swooner_
swooper12389173swooper_
swotters11448473swotters
toolers74416503_toolers
tooters73818773_tooters
troopers10289423troopers
uncovers1336573uncovers
undoers82910573undo_ers
whoopers16286263whoopers
wooers93712443_woo_ers
woofers133810583_woofers
woolers104214023_woolers

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 Limit1461622267.76318828.0
3Display Results2262260.0962354.2
 (SQL Overall)1786912268.03222247.4
 
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.