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

110 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
penancing143634(None) 
enhancing1545822_enhancing
financing1544072financing
menacing1339782mena_cing
peacing124117072pe_a_cing
penning103616492pen_n_ing
prancing132612162p_rancing
tenanting1036212tenanting
advancing1643063advancing
balancing1435783balancing
beaning103820683be_an_ing
bechancing2044443bechancing
beduncing1543913beduncing
benaming1339693bena_ming
chancing162810283_chancing
dancing113611563__dancing
deaning94020473de_an_ing
decanting132510633decanting
defacing15238683defa_cing
defanging1535333defanging
defencing16226693defencing
demanding14237923demanding
denning93515173den_n_ing
denouncing1443883denouncing
deranging1238063deranging
desanding12207653desanding
dezincing2244183dezincing
eanling81416673_e_anling
enabling1138603_enabling
enacting11311363_enacting
enfacing1467293_enfacing
enlacing1148773_enlacing
enouncing1245583_enouncing
enticing11311803_enticing
entrancing1346783_entrancing
evincing1446183_evincing
fenagling1434553fenagling
fencing132411133fe__ncing
financings1641853financings
glancing1247063_glancing
hennaing1234993hen_naing
kenning124010543ken_n_ing
lancing103314123__lancing
leaning83721203le_an_ing
levanting1345523levanting
meaning103918703me_an_ing
pacing114522753p__a_cing
panging113319113p__anging
panning104019393p__anning
panting104025423p__anting
peaching163613643pe_aching
peaking144317693pe_a_king
pealing104123203pe_a_ling
pearling11912013pe_arling
pedaling122412133peda_ling
pedalling1346663pedalling
peening103318303pe_en_ing
peining104619153pe_in_ing
penalising1347623penalising
penalizing2249923penalizing
penance11313443penanc__e
penanced1338163penanc_ed
penances12312443penanc_es
penang92511113pena___ng
penciling1437413penciling
pending114119773pe__nding
pennine93712953pen_n_ine
petnaping1444543petna_ping
petnapping1442303petnapping
pinnacling1543063pinnacling
pinning103417853pin_n_ing
placing123815283p_la_cing
planing103418253p_lan_ing
planking153513013p_lanking
planning113610223p_lanning
planting113515383p_lanting
poncing122913583p__oncing
pouncing13318883p_ouncing
pranging123012723p_ranging
pranking153813383p_ranking
prefacing17118743prefa_cing
prefinancing2051943prefinancing
prenticing1547883prenticing
punning103414993pun_n_ing
recaning111416693recan_ing
recanting122414823recanting
refacing142512813refa_cing
refencing15188853refencing
refinancing1742833refinancing
rehanging1437563rehanging
relacing112516043rela_cing
relanding112110923relanding
remanding132211143remanding
remanning12229033remanning
renailing102813333renailing
renaming11313693rena_ming
renouncing1345103renouncing
romancing1446043romancing
ropedancing1751713ropedancing
sentencing1345403sentencing
speaning113512243spe_an_ing
tenancies1149173tenancies
tenoning938893tenon_ing
trancing112812023_trancing
valancing1544743valancing
weaning114117193we_an_ing
weanling12118643we_anling
yeaning113814633ye_an_ing
yeanling12107063ye_anling
yenning11369493yen_n_ing

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411107.28320409.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.76523012.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.