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

236 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
piffling174513(None) 
riffling1556111riffling
baffling1756052baffling
biffing163510012biff_ing
coffling1736482coffling
miffing16298402miff_ing
muffling1765502muffling
piaffing1733922piaffing
pickling17239202pickling
piddling13208952piddling
piling95025592pi__ling
pilling103722562pi_lling
pindling122110982pindling
puffing162910942puff_ing
purfling1467762purfling
raffling1567062raffling
riffing144011272riff_ing
rifling112815012ri_fling
ruffling1546092ruffling
skiffling2043102skiffling
sniffling1644092sniffling
spiffing17237082spiff_ing
spiffying2142752spiffying
tiffing14339382tiff_ing
waffling1845422waffling
whiffling2242882whiffling
ailing74331013ai__ling
baffing164011603baff_ing
biffin14369103biff_in_
biffins15358533biff_ins
billing103823853bi_lling
birling104317053bi_rling
boffing16339983boff_ing
buffing163411393buff_ing
circling1338423circling
coffing163811253coff_ing
coiffing1755933coiff_ing
cuffing163210253cuff_ing
cufflink20152883cufflink
daffing15369733daff_ing
defiling132812463defiling
dialing94318173di_aling
dialling10310783dialling
dibbling14247333dibbling
diddling12228743diddling
differing1746473differing
diffusing1743853diffusing
dimpling14199023dimpling
dindling112411163dindling
dirling93316073di_rling
doffing15357793doff_ing
fiddling14217873fiddling
fifing134212343fi_f_ing
filing103823763__filing
filling113520803fi_lling
fizzling20264993fizzling
fling97023513___fling
gaffing15379733gaff_ing
gifting123810893gi_fting
giggling10227043giggling
gilling93520383gi_lling
girdling1146823girdling
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
paddling13218643paddling
paling93530133p__aling
palling104024483p_alling
paneling111013623paneling
parling103823763p_arling
paroling113316213paroling
pealing104123203p_ealing
pearling11912013pearling
pebbling1535073pebbling
pedaling122412133pedaling
peddling13217973peddling
peeling102919873p_eeling
peopling1338353peopling
periling11316863periling
pestling111010253pestling
pettling1168213pettling
picking163418333pi_cking
picolin11310883picolin_
picoline12310853picoline
picolins1239853picolins
picoting1338883picoting
piecing12410453pi_ecing
pieing93917653pi__eing
piercing1346663piercing
piffle14418233piffl__e
piffled16366403piffl_ed
piffles15368763piffl_es
pigging123614673pi_gging
piing85218833pi___ing
piking133719643pi__king
pilfering1536393pilfering
pilings103313613pi__lings
piloting1139693piloting
pimping143812123pi_mping
pinching163711053pinching
pinfolding1743013pinfolding
pinging113419553pi_nging
pining93726533pi__ning
pinking143918943pi_nking
pinning103417853pi_nning
pipeline12149503pipeline
piping114017453pi__ping
pipping113414743pi_pping
piquing1935873pi_quing
pirating11314513pirating
pishing134314373pi_shing
pissing103914803pi_ssing
pistoling1268493pistoling
pitching163411113pitching
pithing134014053pi_thing
pitting103618873pi_tting
pitying132910243pi_tying
pivoting1436183pivoting
poling93526503p__oling
polling102920383p_olling
pooling103219093p_ooling
poppling12227323poppling
prefiling1549533prefiling
prickling1836533prickling
prilling113413413prilling
profiling1548233profiling
prowling1449993prowling
puddling13218033puddling
puffin141149003puff_in_
puffins15278913puff_ins
puling93621403p__uling
pulling103821073p_ulling
pungling12228663pungling
purflings1554093purflings
purling103620293p_urling
purpling1368543purpling
puzzling19225393puzzling
reffing143712173reff_ing
refiling123116533refiling
riddling11249443riddling
ridgling11258203ridgling
riesling939013riesling
riflings12227303ri_flings
rifting113515003ri_fting
riling74227973ri__ling
rilling84023623ri_lling
rimpling13219663rimpling
rippling13197573rippling
rivaling1239913rivaling
ruffing143210843ruff_ing
scuffling1843613scuffling
shuffling1933453shuffling
sibling10814423si_bling
sickling152910333sickling
sideling101012183sideling
sidling9915423si_dling
sifting113014593si_fting
singling101913003singling
sizzling17225783sizzling
snaffling1643763snaffling
sniffing15227453sniff_ing
snuffling1643563snuffling
spieling113212523spi_eling
spiling102919703spi__ling
spilling113113943spi_lling
spindling13136273spindling
spiraling1237953spiraling
stiffing15248703stiff_ing
stifling122110913stifling
tickling15309433tickling
tiffin12327933tiff_in_
tiffining1642913tiffining
tiffins13327983tiff_ins
tiling73426553ti__ling
tilling83522783ti_lling
tingling102210823tingling
tinkling13239233tinkling
tippling13196703tippling
tirling83315733ti_rling
titling83715793ti_tling
trifling122411503trifling
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
yaffing17337823yaff_ing
zizzling16233923zizzling

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 Limit1461622366.30023200.3
3Display Results2362360.1102145.5
 (SQL Overall)1786912366.83026162.7
 
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.