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

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

93 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
appealing144649(None) 
appearing1436891appearing
appeasing1446341appeasing
annealing1047452annealing
appalling1444922appalling
appealingly1952242appealingly
appending1536282appending
pealing104123202__pealing
rappeling1435962rappe_ling
rappelling1544362rappelling
repealing122513542repealing
unappealing1652192unappealing
abseiling1265343abseiling
anearing9413973a_nearing
aneling82719503a_ne_ling
angeling102811733ange_ling
appareling1543423appareling
apparelling1652433apparelling
appeal103911613appeal___
appealed1335603appeal_ed
appealer1245743appeal_er
appealers1345063appealers
appeals11378673appeal__s
appellant1346353appellant
appetising1544513appetising
appetizing2445403appetizing
applauding1642103applauding
applying1634653app_lying
apposing1337403app_osing
appraising1545763appraising
apprising1447963apprising
apprizing2347193apprizing
approving1745053approving
asperating1349563asperating
aspersing1237603aspersing
asphalting1643383asphalting
atheling1249203athe_ling
aureoling1045873aureoling
coappearing1842763coappearing
cupeling1338863cupe_ling
cupelling1436283cupelling
dappling1436843dapp__ling
dealing94323233__dealing
empaling1338363emp_aling
expelling1936133expelling
happening1735593happe_ning
healing113922963__healing
impaling1338253imp_aling
impearling1543063impearling
impelling1436913impelling
lappering14258843lappe_ring
paling93530133__p_aling
paneling111013623pane_ling
panelling1239073panelling
papering132213313pape_ring
peacing124117073__peacing
peaking144317693__peaking
pearling11912013__pearling
pedaling122412133_pedaling
peeling102919873__peeling
pleading123011443_pleading
pleasing112611593_pleasing
pleating112916053_pleating
reappearing1643943reappearing
repeating122618983repeating
repelling122312753repelling
resealing102115673resealing
revealing132611883revealing
sealing83528563__sealing
shealing123415463_shealing
speaking153212493_speaking
speaning113512243_speaning
spearing113216103_spearing
speeling112713123_speeling
speiling113612973_speiling
spelling113315233_spelling
spieling113212523spie_ling
spiraling1237953spiraling
spreading1339653spreading
squealing1935153squealing
stealing93416603_stealing
unsealing10711043unsealing
upbearing1435033upbearing
upheaping1743853upheaping
upheaving1843803upheaving
upleaping1434363upleaping
uppiling1335853upp_iling
uprearing1238373uprearing
upscaling1444653upscaling
uptearing1236103uptearing
upwelling1535233upwelling
vealing114217423__vealing
yealing112716383__yealing

Search took 9 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.423422437.4
2DLD Change Limit148641937.59319576.1
3Display Results93930.0462021.7
 (SQL Overall)178691938.06222164.6
 
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.