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 “painkilling” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
painkilling185230(None) 
anvilling1336833_a_nvilling
painkiller1662153painkill_er
painkillers1761773painkillers
panelling1239073pa_n_elling
pencilling1545473p_encilling
pinballing1544013p_inballing
ankling122912064_a_nk__ling
annulling1045004_a_nnulling
anticling12310694_a_nticling
anviling1239744_a_nvi_ling
backfilling2352614backfilling
bankrolling1852304ba_nkrolling
canalling1239554ca_n_alling
cancelling1547214ca_ncelling
cavilling1536384ca__villing
crinkling16145864crink__ling
distilling1247794_distilling
gaingiving16111794gaingi_ving
hanselling1445624ha_nselling
infalling1356244__infalling
inkling122911304__ink__ling
instilling1145804__instilling
intitling1037214__intitling
inwalling1385634__inwalling
killing123118724____killing
landfilling1652404landfilling
mainlining1343874mainli_ning
misbilling1545544_misbilling
nickelling1743644_nickelling
nilling83619564___n_illing
outkilling1545264_outkilling
overkilling1965064overkilling
paiking143814814pai_k___ing
paining103920244pain____ing
painstaking1852854painstaking
painting113614424pain___ting
palling104024484pa____lling
paneling111013624pa_n__eling
panellings1344534pa_n_ellings
panicking1835294pa_n_icking
parboiling1545174parboi_ling
parcelling1546174pa_rcelling
patinizing2248614patin_i_zing
patrolling1345694pa_trolling
penciling1437414p_enci_ling
pencillings1652404p_encillings
penicillin1453504penicillin_
penicillins1553344penicillins
perilling12410004p__erilling
pickling17239204p_ick__ling
pilling103722564p____illing
pindling122110984p_in__dling
pinfolding1743014p_infolding
pinioning1246864p_in_ioning
pinkening1634994p_ink_ening
pinking143918944p_ink___ing
pinnacling1543064p_innacling
pistolling1345354p_istolling
plinking153611244plink___ing
pointillism1553004pointillism
pointillist1354254pointillist
prebilling1595414p_rebilling
prechilling1943744prechilling
predrilling1543674predrilling
prickling1836534prick__ling
prilling113413414p___rilling
princeling1544654prin_celing
prinking153212454prink___ing
rankling132610114ra_nk__ling
sandalling1245874sa_ndalling
skilling132911334___skilling
spancelling1643344spa_ncelling
sprinkling1743824sprink__ling
stencilling1443234stencilling
tinkling13239234_tink__ling
tinselling1145524_tinselling
twinkling1743644twink__ling
unwilling1337164__unwilling
vanillin1145904va_n_illin_
vanillins1245544va_n_illins
windmilling1851774_windmilling
winkling16298294_wink__ling
wrinkling17144954wrink__ling
zinkifying3042684_zinkifying

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819858.94016646.4
3Display Results85850.0461847.8
 (SQL Overall)178691859.42218965.3
 
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.