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

142 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
rappeling143596(None) 
rappelling1544361rappelling
appealing1446492_appealing
dappling1436842dapp_ling
grappling1544992grapp_ling
happening1735592happening
lappering14258842lappering
rapping123619102rapp__ing
raveling123414372ra_veling
rippling13197572ripp_ling
aneling82719503_a_neling
angeling102811733_angeling
appalling1444923_appalling
appareling1543423_appareling
appearing1436893_appearing
appeasing1446343_appeasing
appending1536283_appending
applying1634653_applying
apposing1337403_apposing
atheling1249203_atheling
barreling1238043barreling
cageling12310843ca_geling
canceling14310163canceling
capelin11510973ca_pelin_
capelins12311133ca_pelins
capering132414963ca_pering
capping143819673capp__ing
capsuling1444533capsuling
carpeting1439483carpeting
coppering162810893coppering
crapping153911453crapp__ing
crippling1644093cripp_ling
cupeling1338863_cupeling
dampening1535463dampening
dapping133714793dapp__ing
frapping16348103frapp__ing
gapping134214783gapp__ing
gaveling133410163ga_veling
grapplings1642323grapp_lings
graveling1457383gra_veling
hampering1738863hampering
hanseling1338063hanseling
happenings1842623happenings
happing153817233happ__ing
hoppling16206763hopp_ling
kippering18205443kippering
labeling11311643la_beling
lapping124117023lapp__ing
laureling1035643laureling
lippening14234943lippening
lippering14217883lippering
loppering14237283loppering
mapping143413993mapp__ing
marveling1537103marveling
napping123514183napp__ing
pampering1638383pampering
paneling111013623pa_neling
papering132213313pa_pering
parceling1438443parceling
paupering1437273paupering
peeling102919873__peeling
peppering1337083peppering
poppling12227323popp_ling
rabbeting1445183rabbeting
rabbling13239333ra_bbling
racheting1537793racheting
racketing1647873racketing
raddling11229773ra_ddling
raffling1567063ra_ffling
railing83325643ra__iling
ralphing1435413ralp_hing
rambling131810773ra_mbling
rampaging1544513rampaging
ramping123316873ramp__ing
rankling132610113ra_nkling
raping94829853ra_p__ing
rappel104211953rappel___
rappeled1335003rappel_ed
rappelled1443703rappelled
rappels11448803rappel__s
rappen103512713rappe__n_
rappini11347573rapp__ini
rapturing1245353rapturing
rasping104316253rasp__ing
rassling939013ra_ssling
rattening10288763rattening
rattling92510873ra_ttling
ravelin102211023ra_velin_
ravelings13377383ra_velings
ravelins113011603ra_velins
ravelling13269243ravelling
ravening122611293ra_vening
razeeing1834363ra_zeeing
reappearing1643943reappearing
reapplying1843023reapplying
reeling83126863r__eeling
refeeling13229313refeeling
refueling13227973refueling
reheeling13218263reheeling
reopening1248823reopening
repaneling1345733repaneling
repapering1547043repapering
repealing122513543repealing
repelling122312753repelling
repolling122110203repolling
repping123314983repp__ing
respelling1347973respelling
reveling123117083r_eveling
ridgeling12155263ridgeling
rimpling13219663rimp_ling
ripening1138573r_ipening
ripping123315743ripp__ing
roweling122811123r_oweling
rumpling13178763rump_ling
sampling13510643samp_ling
sapling103217863sa_p_ling
sapping123519313sapp__ing
speeling112713123_speeling
spieling113212523_spieling
suppling1359043supp_ling
tampering1438453tampering
tapeline10310363ta_peline
tapering112112503ta_pering
tapping123317133tapp__ing
tasseling1035853tasseling
tippling13196703tipp_ling
toppling13197353topp_ling
trameling1249053tra_meling
trammeling1544023trammeling
trampling1436973tramp_ling
trapesing1247263tra_pesing
trapping132911393trapp__ing
traveling1349053tra_veling
unappealing1652193unappealing
uppiling1335853_uppiling
wapping153514603wapp__ing
wrapping16297623wrapp__ing
yapping153412613yapp__ing
zapping213211473zapp__ing
zeppelin2142203zeppelin_
zeppelins2242193zeppelins
zippering23215203zippering

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.406440125.6
2DLD Change Limit1486411426.62322443.2
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.09225196.1
 
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.