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

230 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
rufflers1434719(None) 
mufflers16316001mufflers
rafflers14317361rafflers
rifflers14336441rifflers
ruffler13369721ruffler_
ruffles133512271ruffle_s
bafflers16356592bafflers
buffers153310792buff_ers
cuffless1634292cuffless
duffers143410092duff_ers
duffles14308922duffle_s
muffler15398342muffler_
muffles153910452muffle_s
puffers15349202puff_ers
purflers13216962purflers
raffler13339222raffler_
raffles133611842raffle_s
riffler13328352riffler_
riffles133911162riffle_s
riflers103512192r_iflers
ruffes124112422ruff_e_s
ruffle124111672ruffle__
ruffled14369152ruffle_d
rufflier1434012rufflier_
rulers64317092ru__lers
rumblers123610742rumblers
rustlers8339852rustlers
scufflers17285032scufflers
shufflers18265152shufflers
snufflers15285222snufflers
suffers133113542suff_ers
truffles1485592truffle_s
wafflers17306322wafflers
baffler15418113baffler_
baffles153710683baffle_s
bluffers16405703bluff_ers
bubblers11448943bubblers
bucklers16349503bucklers
buffer144512683buff_er_
buffeters1783143buffeters
buffets15317593buff_ets
buffier1568403buffier_
buglers105115323bu_glers
bumblers143710733bumblers
bundlers11399183bundlers
bunglers11398483bunglers
burblers12399263burblers
burlers94120273bu_rlers
bustlers104210623bustlers
butlers94518053bu_tlers
coffers154112693coff_ers
coffles152610003coffle_s
crullers1047303cru_llers
cuddlers12388383cuddlers
cullers93418853cu_llers
cupelers1266733cupelers
curdlers11368493curdlers
curlers94218073cu_rlers
cutlers94217003cu_tlers
defilers12439473defilers
differs14339973diff_ers
doffers14359853doff_ers
duelers83412053du_elers
duellers9268223duellers
duffels14296453duff_els
duffer134711663duff_er_
duffle13368533duffle__
filers94623723__filers
fluffers13335293fluff_ers
fuelers103912393fu_elers
fuellers11277983fuellers
fullers103817373fu_llers
fumblers15318713fumblers
furlers104214223fu_rlers
gaffers14428713gaff_ers
gauffers1563833gauff_ers
goffers14409213goff_ers
gruelers936173gru_elers
gruellers1034183gruellers
gruffer1475793gruff_er_
gruffier1544703gruffier_
gruffness1692743gruffness
grumblers14245023grumblers
guttlers9306933guttlers
guzzlers17274863guzzlers
huddlers13337633huddlers
huffier1637493huffier_
hullers103616263hu_llers
humblers15379803humblers
hurdlers12337493hurdlers
hurlers103714323hu_rlers
hustlers11349203hustlers
jugglers17366523jugglers
jumblers19358323jumblers
krullers1234133kru_llers
lullers73213353lu_llers
muddlers12428813muddlers
muffle14339643muffle__
muffled16377783muffle_d
mufflered1842123mufflered
mullers93217303mu_llers
mumblers14328763mumblers
muzzlers18245203muzzlers
niffers13287363niff_ers
nuzzlers16244753nuzzlers
offers12349963_off_ers
piffles15368763piffle_s
proffers16126593proff_ers
profilers14236293profilers
puddlers12298683puddlers
puffer144610733puff_er_
puffery18235113puff_ery
puffier1547973puffier_
pulers83820283pu__lers
pullers93618483pu_llers
purfler12248733purfler_
purfles122511843purfle_s
puzzlers18295143puzzlers
quaffers2333963quaffers
quellers17237533quellers
rabblers123810853rabblers
raffle123910703raffle__
raffled14429083raffle_d
rafters103715633r_afters
railers74420663r_ailers
ramblers124010373ramblers
rattlers83510293rattlers
ravelers113310863ravelers
reefers103312593reef_ers
reelers73520273r_eelers
refers93921083r_ef_ers
refiles104122423refile_s
refilters1236103refilters
refiners114713313refiners
reflets103513153r_eflets
refusers11499273refusers
refuters11449613refuters
regalers94311133regalers
reifiers11309843reifiers
reoffers1434693reoffers
revelers113414133revelers
revilers114011693revilers
riddlers10269103riddlers
riffle124210233riffle__
riffled14338603riffle_d
rifler94014263r_ifler_
riflery13345803r_iflery
rifles94217703r_ifle_s
riftless1136943riftless
ripplers12337113ripplers
rolfers104011813rolf_ers
rollers73117473r_ollers
roofers105013903roof_ers
roofless11316733roofless
rubbers113913193ru_bbers
rubbles113715113rubble_s
rubles83921703ru_ble_s
ruckles133414603ruckle_s
rudders93210653ru_dders
ruddles92813873ruddle_s
ruers515019413ru___ers
ruffe114713813ruff_e__
ruffed134312743ruff_e_d
ruffians1443793ruffians
ruffliest1554493ruffliest
rufflike1843253rufflike
ruffling1546093ruffling
ruffly15336673ruffl__y
ruffs114516743ruff___s
ruggers94612313ru_ggers
ruiners74213023ru_iners
ruleless836633ruleless
ruler54923343ru__ler_
rules55234253ru__le_s
rumbler113514113rumbler_
rumbles114018393rumble_s
rummers113513653ru_mmers
rumples113313133rumple_s
rumpless12256543rumpless
rundles83214713rundle_s
rundlets9307363rundlets
rungless956733rungless
runkles114111943runkle_s
runless72810423ru_nless
runlets73310773ru_nlets
runners74212453ru_nners
runovers1134473runovers
rushers103816103ru_shers
rustler73512343rustler_
rustles73416413rustle_s
rustless83510243rustless
ruthless1135413ruthless
rutiles74315843rutile_s
scuffers16307493scuff_ers
scuffler16286703scuffler_
scuffles16287863scuffle_s
shuffler17306803shuffler_
shuffles17297783shuffle_s
siffleurs1541643siffleurs
snifflers15275053snifflers
snuffers14326923snuff_ers
snuffler14317413snuffler_
snuffles14318413snuffle_s
souffles14298123souffle_s
stiflers11238833stiflers
stuffers14277383stuff_ers
stuffless1543543stuffless
sucklers14379963sucklers
suffer124314513suff_er_
sufferers1555103sufferers
sufficers17204533sufficers
surfers103614133surf_ers
sutlers73116973su_tlers
triflers113110213triflers
troffers14125433troff_ers
trucklers15295583trucklers
truffes1356773truff_e_s
truffle1384893truffle__
truffled1563993truffle_d
trundlers10215003trundlers
tuffets13266523tuff_ets
tufters10298353tu_fters
tumblers123110623tumblers
tummlers12295703tummlers
turfless1135533turfless
turtlers8258203turtlers
waffler16377783waffler_
waffles16329983waffle_s
whifflers2142773whifflers
zaffers22386773zaff_ers

Search took 7 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.420425454.8
2DLD Change Limit1461622306.36022981.4
3Display Results2302300.0932473.1
 (SQL Overall)1786912306.87325999.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.