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

82 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
tarpapers134427(None) 
tarpaper1244601tarpaper_
tappers113416542ta_p_pers
taxpayers2141892taxpayers
threapers1444772threapers
trappers123711042trap_pers
arrayers11125853_arrayers
bagpipers1641773bagpipers
barraters1138043barraters
cappers134419403ca_p_pers
carmakers1736913carmakers
carpers114521253car__pers
catnapers1364763catnapers
crappers144011023crap_pers
curlpapers1641433curlpapers
drapers105313353_dr_apers
endpapers1443643endpapers
flypapers1942033flypapers
gunpapers1442423gunpapers
hanapers1346963ha_napers
harpers124916203har__pers
lappers113717463la_p_pers
larrupers1142523larrupers
mappers133313783ma_p_pers
nappers114214863na_p_pers
narraters946703narraters
oilpapers1342833oilpapers
papers105125323___papers
paraders113113113par_aders
parapets1239763par_apets
partakers1536563partakers
rampagers1443863rampagers
rapers84327183__r_apers
rappers113618443ra_p_pers
reapers93520453__reapers
repapers1258833_repapers
sandpapers15113713sandpapers
sappers113518903sa_p_pers
sarapes94617743sar_ape_s
scrapers125510523scr_apers
scrappers1545853scrappers
stargazers2041803stargazers
strappers1346743strap_pers
tamperers13227313tamperers
tampers113516743ta__mpers
tanagers9259003ta_nagers
tapadera1153303ta_padera
tapaderas1243053ta_paderas
tapadero1143193ta_padero
tapaderos1242373ta_paderos
taperers10269773ta_perers
tapers84025813t___apers
tapper104419613ta_p_per_
tappets113610013ta_p_pets
tapsters10318803ta_psters
tarpans92513533tarpa__ns
tarriers83411713tar_riers
tarsiers8298533tar_siers
tartars73313403tarta__rs
taxpayer2041813taxpayer_
threaders1365743threaders
threaper1345143threaper_
tippers113414353t_ip_pers
toppers113914603t_op_pers
tracers94917843t_r_acers
traders84316953t_r_aders
trampers123210393t_rampers
trapes85024463t_r_ape_s
trapper113912803trap_per_
treaders93311843t_readers
treaters83615843t_reaters
trippers123210163t_rippers
troopers10289443t_roopers
troupers10359443t_roupers
wallpapers1742653wallpapers
warmakers1845633warmakers
warpages1437053warpage_s
warpers123413583war__pers
warpowers1744553warpowers
wrappers15306933wrap_pers
yappers144012253ya_p_pers
zappers203911633za_p_pers

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.1561145455.1
2DLD Change Limit148641827.93618730.0
3Display Results82820.0332484.8
 (SQL Overall)178691828.12521992.7
 
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.