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

282 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
riffling155611(None) 
piffling1745131piffling
raffling1567061raffling
riffing144011271riff_ing
rifling112815011ri_fling
ruffling1546091ruffling
baffling1756052baffling
biffing163510012biff_ing
coffling1736482coffling
miffing16298402miff_ing
muffling1765502muffling
reffing143712172reff_ing
refiling123116532refiling
riddling11249442riddling
ridgling11258202ridgling
riesling939012riesling
riflings12227302ri_flings
rifting113515002ri_fting
riling74227972ri__ling
rilling84023622ri_lling
rimpling13219662rimpling
rippling13197572rippling
rivaling1239912rivaling
ruffing143210842ruff_ing
skiffling2043102skiffling
sniffling1644092sniffling
tiffing14339382tiff_ing
trifling122411502tri_fling
waffling1845422waffling
whiffling2242882whiffling
ailing74331013ai__ling
baffing164011603baff_ing
biffin14369103biff_in_
biffins15358533biff_ins
billing103823853bi_lling
birling104317053bi_rling
boffing16339983boff_ing
bridling122610583bri_dling
briefing1436943brief_ing
brisling112410843bri_sling
bristling1246663bristling
brittling1235543brittling
buffing163411393buff_ing
circling1338423circling
coffing163811253coff_ing
coiffing1755933coiff_ing
crimpling1645343crimpling
crinkling16145863crinkling
crippling1644093crippling
cuffing163210253cuff_ing
cufflink20152883cufflink
daffing15369733daff_ing
defiling132812463defiling
dialing94318173di_aling
dialling10310783dialling
dibbling14247333dibbling
diddling12228743diddling
differing1746483differing
diffusing1743863diffusing
dimpling14199023dimpling
dindling112411163dindling
dirling93316073di_rling
doffing15357793doff_ing
dribbling1533713dribbling
drifting13338733dri_fting
drilling103311983dri_lling
driveling1445763driveling
drizzling1943023drizzling
fiddling14217873fiddling
fifing134212343fi_f_ing
filing103823763__filing
filling113520803fi_lling
fizzling20264993fizzling
fling97023513___fling
fribbling1733673fribbling
frilling123011493fri_lling
frivoling1644493frivoling
frizzling2153113frizzling
gaffing15379733gaff_ing
gifting123810893gi_fting
giggling10227043giggling
gilling93520383gi_lling
girdling1146823girdling
griddling1333933griddling
griffin1434513griff_in_
griffins1544783griff_ins
grifting13299263gri_fting
grilling103811533gri_lling
grizzling1942843grizzling
gruffing1635273gruff_ing
higgling14217163higgling
hilling113821773hi_lling
hireling121210993hireling
hirpling1467223hirpling
hirsling1277543hirsling
huffing17278833huff_ing
idling8912883_i_dling
inkling122911303_inkling
isling71213883_i_sling
jiggling18226363jiggling
jingling17188573jingling
kibbling17225703kibbling
killing123118723ki_lling
kindling14229623kindling
kitling123313573ki_tling
kittling1336063kittling
libeling1139873libeling
lifeline11167663lifeline
lifelong1242633lifelong
lifting113313273li_fting
luffing143310103luff_ing
miauling1137343miauling
middling13249343middling
milling103223683mi_lling
mingling122010933mingling
misfiling1537223misfiling
mizzling19255443mizzling
muffing163210403muff_ing
naffing14359033naff_ing
nibbling13256503nibbling
nickling15278703nickling
niffering1645133niffering
niggling11227443niggling
nilling83619563ni_lling
offing13368643_off_ing
offline1345783_offline
oiling74925313oi__ling
piaffing1733923piaffing
pickling17239203pickling
piddling13208953piddling
piling95025593pi__ling
pilling103722563pi_lling
pindling122110983pindling
prefiling1549533prefiling
prickling1836533prickling
prilling113413413pri_lling
profiling1548233profiling
puffing162910943puff_ing
purfling1467763purfling
rabbling13239333rabbling
raddling11229773raddling
rafting113815753r_afting
railing83325643r_ailing
rambling131810773rambling
rankling132610113rankling
rassling939013rassling
rattling92510873rattling
raveling123414373raveling
reddling112911813reddling
reedling102414273reedling
reefing114016863reef_ing
reeling83126863r_eeling
refacing142512813refacing
refalling132010423refalling
refeeling13229313refeeling
refelling132211313refelling
refilling13299333refilling
refilming15256463refilming
refining122416863refining
refiring123513923refiring
refixing19329793refixing
reflying15268173reflying
refolding1437453refolding
refrying15278903refrying
refueling13227973refueling
refuging13218423refuging
refusing122310873refusing
refuting121911903refuting
regaling10315363regaling
reifying1539383reifying
reoiling93217213reoiling
resiling93520173resiling
resoling92916303resoling
retiling93319483retiling
reveling123117083reveling
reviling122917213reviling
ribbing123111953ri_bbing
ricing94822763ri__cing
ricking143920233ri_cking
ridding103314193ri_dding
ridgeling12155263ridgeling
ridging104112983ri_dging
ridglings12214183ridglings
riding84325963ri__ding
rieslings1034493rieslings
riffle124210233riffl__e
riffled14338603riffl_ed
riffler13328353riffl_er
rifflers14336443rifflers
riffles133911163riffl_es
riflip1134723ri_fli_p
riflips1234163ri_flips
rigging103016333ri_gging
righting132610853righting
riming93322223ri__ming
rimming123411073ri_mming
ringing93521283ri_nging
rinning83216743ri_nning
rinsing82516113ri_nsing
rioting82716393ri_oting
ripening1138573ripening
riping93821613ri__ping
ripping123315743ri_pping
rising74025883ri__sing
risking123914243ri_sking
rivalling1335963rivalling
riveting12139443riveting
riving104521423ri__ving
rockling15259383rockling
roiling83220453r_oiling
rolfing113710653rolf_ing
rolling83620413r_olling
roofing113814353roof_ing
roofline1136193roofline
rootling9269953rootling
roweling122811123roweling
rubbling13238073rubbling
ruckling15258573ruckling
ruddling11228553ruddling
rufflier1434013rufflier
rufflike1843253rufflike
ruling73219553r__uling
rumbling131910103rumbling
rumpling13178763rumpling
runkling13217613runkling
rustling9249983rustling
scuffling1843613scuffling
shuffling1933453shuffling
sibling10814423si_bling
sickling152910333sickling
sideling101012183sideling
sidling9915423si_dling
sifting113014593si_fting
singling101913003singling
sizzling17225783sizzling
snaffling1643763snaffling
sniffing15227453sniff_ing
snuffling1643563snuffling
spiffing17237083spiff_ing
spiffying2142753spiffying
stiffing15248703stiff_ing
stifling122110913stifling
tariffing1644113tariff_ing
tickling15309433tickling
tiffin12327933tiff_in_
tiffining1642923tiffining
tiffins13327983tiff_ins
tiling73426553ti__ling
tilling83522783ti_lling
tingling102210823tingling
tinkling13239233tinkling
tippling13196703tippling
tirling83315733ti_rling
titling83715793ti_tling
trickling1647723trickling
triflings13235973tri_flings
trilling92815963tri_lling
trindling1137133trindling
tripling112712553tri_pling
upfling1337093_upfling
vialing113614163vi_aling
vialling1237223vialling
vittling1236143vittling
waffing173710243waff_ing
wafflings1943023wafflings
whiffing2134703whiff_ing
widdling14228743widdling
wifing133513393wi_f_ing
wiggling14217293wiggling
wildling13248083wildling
wiling103024293wi__ling
willing113821613wi_lling
wimbling16186543wimbling
wimpling16207483wimpling
windling132212263windling
winkling16298293winkling
wintling12249923wintling
witling113215813wi_tling
wriggling1533813wriggling
wrinkling17144953wrinkling
yaffing17337823yaff_ing
zizzling16233923zizzling

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 Limit1461622826.65621959.4
3Display Results2822820.1102563.6
 (SQL Overall)1786912827.18924856.2
 
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.