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

65 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
didapper144295(None) 
didappers1543171didappers
dapper114016632__dapper
diaper94513112di_a_per
dipper114017792di__pper
disappear1442492disappear
kidnapper1842012kidnapper
adapter1036173_adapter
capper124421983__capper
clapper134011863_clapper
crapper133913193_crapper
damper114117753__damper
dapped124516763__dapped
dialer74315433di_a_ler
dialler848813di_aller
diapers104713913di_a_pers
diapir9357113di_a_pir
diaster82813313di_aster
diddler103511513did_dler
dilater83515653dila_ter
diopter1038473di_opter
dipped123517493di__pped
dippers123615183di__ppers
dippier123111393di_ppier
disabler1147913disabler
disappears1542563disappears
disarmer1138033disarmer
disaster949943disaster
dognapper1542433dognapper
draper94315693d_ra_per
dripper12349233d_ripper
dropper12329873d_ropper
endpaper1343883endpaper
flapper14359203_flapper
gipper114215303gi__pper
hipper133818023hi__pper
kidnaper1552593kidnaper
kidnapped1941773kidnapped
kidnappee1851843kidnappee
kidnappers1951823kidnappers
kipper143414213ki__pper
knapper15387153_knapper
lapper104319953__lapper
lipper104219633li__pper
mapper124516093__mapper
napper103718283__napper
nipper103715713ni__pper
oilpaper1242853oilpaper
rapper104621573__rapper
ripper103518653ri__pper
sapper103822353__sapper
scrapper1466963scrapper
sipper103920993si__pper
slapper113512463_slapper
snapper113512073_snapper
strapper1258093strapper
swapper14359703_swapper
tapper104419613__tapper
tipper103918413ti__pper
trapper113912803_trapper
whapper17348273_whapper
wrapper14368333_wrapper
yapper133714513__yapper
zapper193414023__zapper
zipper193813123zi__pper

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 Filter1786911461620.313570897.8
2DLD Change Limit146162657.45319611.2
3Display Results65650.0302166.7
 (SQL Overall)178691657.79622920.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.