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

60 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
didappers154317(None) 
didapper1442951didapper_
diapers104713912di_a_pers
dippers123615182di__ppers
disappears1542562disappears
kidnappers1951822kidnappers
adapters1136103_adapters
cappers134419403__cappers
clappers143310833_clappers
crappers144011023_crappers
dampers123915693__dampers
dapper114016633__dapper_
dialers83614303di_a_lers
diallers957773di_allers
diaper94513113di_a_per_
diapirs10347643di_a_pirs
diasters92913183di_asters
diddlers11359153did_dlers
dilaters92513063dila_ters
diopters1137693di_opters
dipper114017793di__pper_
disablers1255803disablers
disappear1442493disappear
disarmers1246943disarmers
disasters1039153disasters
dognappers1642053dognappers
drapers105313353d_ra_pers
drippers13327943d_rippers
droppers13318603d_roppers
endpapers1443643endpapers
flappers15388383_flappers
gippers123212083gi__ppers
kidnapers1652473kidnapers
kidnappees1951243kidnappees
kidnapper1842013kidnapper_
kippers153211433ki__ppers
knappers16315643_knappers
lappers113717463__lappers
lippers113416443li__ppers
mappers133313783__mappers
nappers114214863__nappers
nippers113012623ni__ppers
oilpapers1342833oilpapers
rappers113618443__rappers
rippers114115033ri__ppers
sappers113518903__sappers
scrappers1545863scrappers
sippers113117753si__ppers
slappers123710953_slappers
snappers123510173_snappers
strappers1346743strappers
swappers15358083_swappers
tappers113416543__tappers
tippers113414353ti__ppers
trappers123711043_trappers
whappers18276743_whappers
wrappers15306933_wrappers
yappers144012253__yappers
zappers203911633__zappers
zippers203310383zi__ppers

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 Limit148641607.14320809.3
3Display Results60600.0302000.0
 (SQL Overall)178691607.60923484.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.