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

87 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
deadpan1122523(None) 
deadman11238421deadman
deadpans12205171deadpans
beadman12249152beadman
bedpan1137582be_dpan
deaden83714322dead_en
deadmen11248572deadmen
headman13229632headman
headpin1336002headpin
leadman10237842leadman
adman84517913__adman
badman113813853_badman
beadmen12299453beadmen
beadsman1355613beadsman
bedpans1237173be_dpans
claypan1434313claypan
dada66422453d_ad_a_
dadas75819863d_ad_as
daedal849083daed_al
daman84821173d_a_man
dampen114310593d_ampen
deacon9510423dea_con
dead65434243dead___
deadbeat1245803deadbeat
deadens93410693deadens
deader84220473dead_er
deadest93014883deadest
deadeye1245163deadeye
deadfall1343313deadfall
deadhead1444433deadhead
deadline10139053deadline
deadly113811473dead_ly
deadpanned1551343deadpanned
deadpanner1471403deadpanner
deads75726913dead__s
deafen10389673dea_fen
dean56039483de___an
decadal1137243decad_al
decuman1236573decuman
dedal75719023de_d_al
dedans85915073de_d_ans
deepen9339193de_epen
deewan10267553de_ewan
demean9510563de_mean
dendron947653dendron
deodand1035713deod_and
deodar837713deod_ar
deskman1444323deskman
desman9311693de_sman
dewan95718043de__wan
dextran1586163dextran
dishpan13105523dishpan
drayman1335433drayman
dustpan1043243dustpan
hardpan1336443hardpan
headband1544843headband
headland1345613headland
headmen13259513headmen
headpins1436103headpins
headsman1446353headsman
headway1745553headway
herdman13238423herdman
japan14411233_ja_pan
leaden74515223lead_en
leadmen10277903leadmen
leadplant1244073leadplant
leadsman1145243leadsman
madman113712393_madman
meatman1137903meatman
median94117543me_dian
radian74117273_radian
readapt1039743readapt
readorn8310483readorn
redan66125013re_d_an
reedman1037723reedman
sampan102511893_sampan
seaman84015903sea_man
seawan94111223sea_wan
sedan65620423se_d_an
seedman1037373seedman
swanpan1243693swanpan
taipan82410663_taipan
tampan102512323_tampan
tarpan82814303_tarpan
teopan839353te_opan
trapan82412973tra_pan
weapon11288113wea_pon

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 Filter1786911340270.420425454.8
2DLD Change Limit134027877.30018359.9
3Display Results87870.0302900.0
 (SQL Overall)178691877.75023056.9
 
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.