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

151 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
scuffler1628670(None) 
scuffer15328881scuff_er
scuffle15266891scuffle_
scuffled17256201scuffled
scufflers17285031scufflers
scuffles16287861scuffles
shuffler17306801shuffler
snuffler14317411snuffler
muffler15398342_muffler
ruffler13369722_ruffler
scoffer15317022scoff_er
scruffier1743302scruffier
scuffed16298242scuff_ed
scuffers16307492scuff_ers
sculler99812152scu_ller
scurfier13267052scurfier
shuffle16276922shuffle_
shuffled18296242shuffled
shufflers18265152shufflers
shuffles17297782shuffles
sniffler14296832sniffler
snuffer13318852snuff_er
snuffier14276942snuffier
snuffle13267832snuffle_
snuffled15277032snuffled
snufflers15285222snufflers
snuffles14318412snuffles
snufflier1543302snufflier
souffle13306802souffle_
souffled15276192souffled
souffles14298122souffles
stuffer13349792stuff_er
stuffier14336622stuffier
suffer124314512s_uff_er
baffler15418113_baffler
bluffer15396883bluff_er
buffer144512683_buff_er
buffier1568403_buffier
chuffer18337143chuff_er
chuffier1934543chuffier
coffer144112863_coff_er
coffle14359043_coffle_
coffled16297363_coffled
coffles152610003_coffles
cuddler113810743_cuddler
cuffed154311213_cuff_ed
cuffless1634293_cuffless
culler84322253_cu_ller
cupeler1177483_cupeler
curdler103511563_curdler
curler85221323_cu_rler
cutler84718033_cu_tler
duffer134711663_duff_er
duffle13368533_duffle_
duffles14308923_duffles
fluffer12336503fluff_er
fluffier13264333fluffier
gauffer1474423gauff_er
gruffer1475793gruff_er
gruffier1544703gruffier
huffier1637493_huffier
muffle14339643_muffle_
muffled16377783_muffled
mufflers16316003_mufflers
muffles153910453_muffles
puffer144610733_puff_er
puffier1547973_puffier
purfler12248733_purfler
raffler13339223_raffler
riffler13328353_riffler
ruffle124111673_ruffle_
ruffled14369153_ruffled
rufflers14347193_rufflers
ruffles133512273_ruffles
rufflier1434013_rufflier
scaler84321603sc__aler
scarfer124511083scarf_er
schiller13296473schiller
sclaffer16112653sclaffer
scoffed16266183scoff_ed
scoffers16286133scoff_ers
scofflaw1941433scofflaw
scowler12248173sc_owler
scrawler1345883scrawler
scuff133914893scuff___
scuffing17287113scuffing
scuffling1843613scuffling
scuffs14419053scuff__s
sculker13318323scu_lker
sculled102911693scu_lled
scullers103510483scu_llers
scullery13296333scu_llery
scumble1337013scumble_
scumbled1535053scumbled
scumbles1447023scumbles
scummer13398753scu_mmer
scummier1445083scummier
scunner9358243scu_nner
scupper1367423scu_pper
scurvier13255883scurvier
scutcher15176963scutcher
scutter93512173scu_tter
scuttle936463scuttle_
scuttled1134533scuttled
scuttles1056503scuttles
scuzzier1842713scuzzier
shuttler1164903shuttler
siffleur1441833s_iffleur
skiffle17225203skiffle_
skiffled19244423skiffled
skiffles18265713skiffles
sluffed14308303sluff_ed
smuggler12244523smuggler
snaffle13216253snaffle_
snaffled15285213snaffled
snaffles14246043snaffles
sniffer13318903sniff_er
sniffier14356643sniffier
sniffle13287653sniffle_
sniffled15276443sniffled
snifflers15275053snifflers
sniffles14257723sniffles
snuffed14308073snuff_ed
snuffers14326923snuff_ers
snuffly16305203snuffl_y
souffleed16272903souffleed
spiffier16255883spiffier
squaller1736083squaller
squealer17115603squealer
squiffier2442843squiffier
staffer13299093staff_er
stiffer13319393stiff_er
stifler102911473s_tifler
stuffed14328973stuff_ed
stuffers14277383stuff_ers
stuffless1543543stuffless
stumbler1235813stumbler
subtler92910843s_ubtler
suckler133413093s_uckler
sufferer1436063s_ufferer
suffers133113543s_uff_ers
sufficer16225823s_ufficer
suppler1148433s_uppler
surfer93515883s_urf_er
surfier102613543s_urfier
sutler63718393s_u_tler
truffle1384893truffle_
truffled1563993truffled
truffles1485593truffles
waffler16377783_waffler
whiffler2033483whiffler

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.203880251.2
2DLD Change Limit1461621517.04620744.0
3Display Results1511510.0463282.6
 (SQL Overall)1786911517.29524495.0
 
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.