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

121 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
scrooges113716(None) 
scrooge1037181scrooge_
scrouges1136681scrouges
scrooches1645702scrooches
scrooped1356402scrooped
scroops11288252scroo_ps
scrouge1036352scrouge_
scrouged1235382scrouged
scrounges1243922scrounges
stooges83611482s_tooges
acreages1138373acreages
acrogen1038203acr_ogen
acrogens1147243acr_ogens
acrosomes1347843acrosomes
chooses125717423_chooses
conges94928173_c_onges
cooees85621893_c_ooees
creoles9913323_creoles
cringes103215503_cringes
crones84729243_cr_ones
cronies9622503_cronies
crooked143910943_crooked
crooker134111093_crooker
crookest1436683_crookest
crooks124914413_croo_ks
crooned103813343_crooned
crooner93714043_crooner
crooners103911393_crooners
croons85418423_croo_ns
crores86121163_cr_ores
crosses94220793_crosses
croupes114613103_croupes
croutes94815653_croutes
crozes174417663_cr_ozes
cryogen1345043_cryogen
cryogens1444723_cryogens
grooves11368803_grooves
horologes1348313horologes
rooses65526233__rooses
rouges76022383__rouges
sarges75128593sar__ges
sarodes84216143sar_odes
sarongs84511803sarong_s
saroses73619333sar_oses
scalages113010253scalages
schmoes14308543schmo_es
schmooses16275633schmooses
schmoozes25214903schmoozes
schnozes2244493schnozes
schooled1447053schooled
schools1249113schoo_ls
schooner1336623schooner
schooners1445663schooners
sconces113811453sc_onces
scones84521303sc__ones
scooches15188413scooches
scooped124611743sc_ooped
scooper113812033sc_ooper
scoopers124210193sc_oopers
scoops105414363sc_oo_ps
scooted103612283sc_ooted
scooter93312873sc_ooter
scooters103511033sc_ooters
scoots85315943sc_oo_ts
scopes104719593sc__opes
scorches15189143scorches
scores84725923sc__ores
scourges1136533scourges
scouses93313243sc_ouses
scragged1335823scragged
scrags95713803scr_ag_s
scraighs1443633scraighs
scrapes116217663scr_apes
scrapies124612473scrapies
screes85023973scr__ees
scribes113713203scr_ibes
scries85226823scr__ies
scrieves13387613scrieves
scrives124414273scr_ives
scrods94111613scr_o_ds
scroggier1343133scroggier
scroggiest1443323scroggiest
scroggy14243843scr_oggy
scrolled1137053scrolled
scrolls938063scr_olls
scrooch1444963scroo_ch
scrooched1763843scrooched
scroop10299783scroo__p
scrootch1542813scrootch
scrootches1743323scrootches
scrotums1243973scrotums
scrounge1143913scrounge_
scrounged1343143scrounged
scrounger1243443scrounger
scroungers1343183scroungers
scruples1237433scruples
scutages1136503scutages
serfages1238233serfages
serges74225973ser__ges
serologies11311333serologies
shmoozes22254883shmoozes
snoozes16289783s_noozes
sorboses1038523sorboses
soroches1338803soroches
soroses73117483sor_oses
splodges1234153splodges
sponges10311043s_ponges
springes114014033springes
stodges9309083s_todges
stooge73811663s_tooge_
stooged94310733s_tooged
storages9311103storages
stranges94516763stranges
strobes93813263str_obes
strokes114316323str_okes
stronger9349693stronger
strongest10338293strongest
strophes13310603strophes
sucroses1039933sucr_oses
surges73924593sur__ges
syringes122810213syringes

Search took 8 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.436409841.7
2DLD Change Limit1461621216.78321548.3
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.26524596.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.