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

70 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
repapering154704(None) 
papering132213312__papering
peppering1337082pep_pering
reappearing1643942reappearing
repairing12310012repa_iring
repaneling1345732repaneling
repowering1645272repowering
beavering1538703be_avering
bediapering1763043bediapering
capering132414963__capering
coppering162810893cop_pering
dewatering1545773dewatering
diapering1339033_diapering
kippering18205443kip_pering
lappering14258843lap_pering
lippering14217883lip_pering
loppering14237283lop_pering
newspapering2051643newspapering
pampering1638383__pampering
paupering1437273__paupering
preparing14311643prepa__ring
rappeling1435963rap_peling
realtering1139473realtering
reaping103621213re_ap__ing
reapplying1843023reapplying
rearing83128783re_a__ring
recapping1636453recap_ping
recapturing1643763recapturing
recarpeting1674363recarpeting
recovering1647373recovering
reentering1149983reentering
regathering1645203regathering
rehammering1953363rehammering
relabeling1344193relabeling
relapsing1236843relap_sing
remapping1635023remap_ping
remastering1446843remastering
renaturing11176803renaturing
rendering112213183re_ndering
reoffering1744093reoffering
reopening1248823re_opening
reordering1266213reordering
repacking1838283repa_cking
repainting13128973repainting
repanelling1443473repanelling
repaper11310023repaper___
repapered1445233repaper_ed
repapers1258833repaper__s
reparking1638923repa_rking
repassing12249423repa_ssing
repasting122312843repa_sting
repatching1844993repatching
repatterning1552173repatterning
repaving142810743repa__ving
repaying142712393repa__ying
reperking1638703re__perking
replastering1553413replastering
repouring12310073rep_ouring
repping123314983rep_p__ing
reprieving1644893reprieving
respiring12159903re_spiring
respring111614063re_sp_ring
retaping113012553retap__ing
retempering1644303retempering
reuttering1137573reuttering
revering122918073re__vering
rewakening1843793rewakening
tapering112112503__tapering
tempering1438733te_mpering
zippering23215203zip_pering

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 Filter1786911406030.406440125.6
2DLD Change Limit140603706.45321788.8
3Display Results70700.0302333.3
 (SQL Overall)178691706.88925938.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.