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 “rifflers” 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
rifflers1433644(None) 
rafflers14317361rafflers
riffler13328351riffler_
riffles133911161riffle_s
riflers103512191ri_flers
rufflers14347191rufflers
bafflers16356592bafflers
differs14339972diff_ers
mufflers16316002mufflers
niffers13287362niff_ers
piffles15368762piffle_s
raffler13339222raffler_
raffles133611842raffle_s
riddlers10269102riddlers
riffle124210232riffle__
riffled14338602riffle_d
rifler94014262ri_fler_
riflery13345802ri_flery
rifles94217702ri_fle_s
riftless1136942riftless
ripplers12337112ripplers
ruffler13369722ruffler_
ruffles133512272ruffle_s
siffleurs1541642siffleurs
snifflers15275052snifflers
triflers113110212tri_flers
wafflers17306322wafflers
whifflers2142772whifflers
baffler15418113baffler_
baffles153710683baffle_s
biffies152710853biffie_s
billers94720833bi_llers
birlers93813003bi_rlers
bridlers11359183bri_dlers
briefers1335143brief_ers
briefless1443613briefless
buffers153310793buff_ers
circlers1235353circlers
coffers154112693coff_ers
coffles152610003coffle_s
cripplers15314993cripplers
cuffless1634293cuffless
defilers12439473defilers
dialers83614303di_alers
diallers957773diallers
dibblers13377583dibblers
diddlers11359153diddlers
differ133910843diff_er_
diffusers1642783diffusers
doffers14359853doff_ers
dribblers14274453dribblers
drifters12417913dri_fters
drillers9429723dri_llers
drivelers1364223drivelers
duffers143410093duff_ers
duffles14308923duffle_s
fiddlers13328283fiddlers
fifers125414923fi_f_ers
filers94623723__filers
fillers104320213fi_llers
fribblers16314193fribblers
frillers11349873fri_llers
frivolers1543473frivolers
frizzlers20293673frizzlers
gaffers14428713gaff_ers
giftless1245173giftless
gigglers11297403gigglers
gillers84216903gi_llers
girdlers10195403girdlers
goffers14409213goff_ers
griffes14367923griff_e_s
grifters12389233gri_fters
grillers93810813gri_llers
grizzlers18253233grizzlers
higglers13297233higglers
hillers103718733hi_llers
idlers74012813_i_dlers
iffier1236763_iffier_
infers93615443_inf_ers
jiffies20327473jiffie_s
jinglers16408763jinglers
killers114215583ki_llers
kindlers13318483kindlers
libelers10238623libelers
lifeless11228143lifeless
lifers95617843li_f_ers
lifters104313783li_fters
middlers123410193middlers
miffier1537023miffier_
milers84625163mi__lers
millers93621343mi_llers
minglers113011293minglers
muffler15398343muffler_
muffles153910453muffle_s
nibblers12306543nibblers
niffer12378443niff_er_
nigglers10307253nigglers
offers12349963_off_ers
oilers64721193oi__lers
piaffers16114203piaffers
piddlers12359593piddlers
piffle14418233piffle__
piffled16366403piffle_d
pilfers1238963pilf_ers
proffers16126593proff_ers
profilers14236293profilers
puffers15349203puff_ers
purflers13216963purflers
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
ribbers113913183ri_bbers
ribiers9319753ri_biers
ribless93410343ri_bless
riblets93412553ri_blets
ricers84120993ri__cers
ridders93612493ri_dders
riddler93411263riddler_
riddles93215023riddle_s
riders74123903ri__ders
ridleys11145783ri_dleys
rievers104311453ri_evers
rifeness1138593rifeness
rifer84721983ri_f_er_
riffed133811563riff_e_d
riffling1556113riffling
riffs115114613riff___s
rifle85518333ri_fle__
rifled104115003ri_fle_d
rifleries1247683ri_fleries
riflips1234163ri_flips
riggers93613843ri_ggers
righters122610713righters
riles55343643ri__le_s
rilles64725503ri_lle_s
rillets74216153ri_llets
rimers84522553ri__mers
rimfires1344203rimfires
rimless9369363ri_mless
rimmers113812883ri_mmers
rimples113114223rimple_s
rindless92510193rindless
ringers83922953ri_ngers
ringlets92910233ringlets
rinsers73815743ri_nsers
rioters73615523ri_oters
ripeners1036843ripeners
rippers114115033ri_ppers
rippler113210103rippler_
ripples113513293ripple_s
ripplets12316733ripplets
risers64624783ri__sers
riskers114011993ri_skers
riskless1235763riskless
ritters74020623ri_tters
rivers94626543ri__vers
riveters11228163riveters
rivulets1174753rivulets
rolfers104011813rolf_ers
rollers73117473r_ollers
roofers105013903roof_ers
roofless11316733roofless
ruffes124112423ruff_e_s
ruffle124111673ruffle__
ruffled14369153ruffle_d
rufflier1434013rufflier_
rulers64317093r__ulers
rumblers123610743rumblers
rustlers8339853rustlers
scufflers17285033scufflers
shufflers18265153shufflers
sidlers83414233si_dlers
siffleur1441833siffleur
sifters103714793si_fters
sillers73822103si_llers
sizzlers16274753sizzlers
skiffles18265713skiffle_s
skiffless19243053skiffless
sniffers14257123sniff_ers
sniffler14296833sniffler_
sniffles14257723sniffle_s
snufflers15285223snufflers
stiflers11238833stiflers
suffers133113543suff_ers
ticklers14339303ticklers
tiddlers10288653tiddlers
tilers63523503ti__lers
tillers73418743ti_llers
tinglers93710593tinglers
tinklers12298183tinklers
tipplers12336353tipplers
titfers10318933titf_ers
trifler103912153tri_fler_
trifles103814823tri_fle_s
trillers83613493tri_llers
troffers14125433troff_ers
truffles1485593truffle_s
waffler16377783waffler_
waffles16329983waffle_s
whiffers2064493whiff_ers
whiffler2033483whiffler_
whiffles2034263whiffle_s
wifeless14277483wifeless
wigglers13257213wigglers
willers103517913wi_llers
wrigglers14273713wrigglers
zaffers22386773zaff_ers

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.423422437.4
2DLD Change Limit1461622267.32619951.1
3Display Results2262260.0932430.1
 (SQL Overall)1786912267.84222786.4
 
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.