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

106 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
scufflers1728503(None) 
scuffers16307491scuff_ers
scuffler16286701scuffler_
scuffles16287861scuffle_s
shufflers18265151shufflers
snufflers15285221snufflers
cuffless1634292_cuffless
mufflers16316002_mufflers
rufflers14347192_rufflers
scoffers16286132scoff_ers
scuffer15328882scuff_er_
scuffle15266892scuffle__
scuffled17256202scuffle_d
scullers103510482scu_llers
shuffler17306802shuffler_
shuffles17297782shuffle_s
snifflers15275052snifflers
snuffers14326922snuff_ers
snuffler14317412snuffler_
snuffles14318412snuffle_s
souffles14298122souffle_s
stuffers14277382stuff_ers
stuffless1543542stuffless
suffers133113542s_uff_ers
bafflers16356593_bafflers
bluffers16405703bluff_ers
buffers153310793_buff_ers
coffers154112693_coff_ers
coffles152610003_coffle_s
cuddlers12388383_cuddlers
cullers93418853_cu_llers
cupelers1266733_cupelers
curdlers11368493_curdlers
curlers94218073_cu_rlers
cutlers94217003_cu_tlers
duffers143410093_duff_ers
duffles14308923_duffle_s
fluffers13335293fluff_ers
gauffers1563833gauff_ers
muffler15398343_muffler_
muffles153910453_muffle_s
puffers15349203_puff_ers
purflers13216963_purflers
rafflers14317363_rafflers
rifflers14336443_rifflers
ruffler13369723_ruffler_
ruffles133512273_ruffle_s
scalers93817263sc__alers
scarfers13408463scarf_ers
schillers14285663schillers
sclaffers17122523sclaffers
scoffer15317023scoff_er_
scofflaws2051173scofflaws
scowlers13257373sc_owlers
scrawlers1434753scrawlers
scruffier1743303scruffier_
scuffed16298243scuff_e_d
scuffling1843613scuffling
scuffs14419053scuff___s
sculkers14306933scu_lkers
sculler99812153scu_ller_
scullery13296333scu_llery
scumbles1447023scumble_s
scumless1254993scu_mless
scummers14277783scu_mmers
scunners10357303scu_nners
scuppers1446543scu_ppers
scurfier13267053scurfier_
scutchers16175643scutchers
scutters103311023scu_tters
scuttles1056503scuttle_s
shuffle16276923shuffle__
shuffled18296243shuffle_d
shuttlers1254123shuttlers
siffleurs1541643s_iffleurs
skiffles18265713skiffle_s
skiffless19243053skiffless
smugglers13263433smugglers
snaffles14246043snaffle_s
sniffers14257123sniff_ers
sniffler14296833sniffler_
sniffles14257723sniffle_s
snuffer13318853snuff_er_
snuffier14276943snuffier_
snuffle13267833snuffle__
snuffled15277033snuffle_d
snufflier1543303snufflier_
souffle13306803souffle__
souffled15276193souffle_d
souffleed16272903souffleed
squallers1834683squallers
squealers1894453squealers
staffers14247083staff_ers
stiflers11238833s_tiflers
stuffer13349793stuff_er_
stuffier14336623stuffier_
stumblers1334383stumblers
sucklers14379963s_ucklers
suffer124314513s_uff_er_
sufferers1555103s_ufferers
sufficers17204533s_ufficers
surfers103614133s_urf_ers
sutlers73116973s_u_tlers
truffles1485593truffle_s
wafflers17306323_wafflers
whifflers2142773whifflers

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411066.92321470.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.42224075.9
 
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.