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 “hardpans” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
hardpans143645(None) 
hardpan1336441hardpan_
hardass1139752hard_ass
hardens113815022hard_ens
hardhats1546832hardhats
hardpack2043922hardpack
hardpacks2143622hardpacks
harijans1845722harijans
harpins123615702har_pins
tarpans92513532tar_pans
arepas85515703_arepa_s
arpens84814823_ar_pens
barchans1588683barchans
bedpans1237173_bedpans
caravans1338613caravans
cardiacs1376913cardiacs
cardias10715113cardia_s
cardigans1345153cardigans
cardons104519933card_ons
cardoons113411943cardoons
carpals113414623car_pals
charpais1536933char_pais
darshans1286543darshans
deadpans12205173deadpans
firepans1347153firepans
frypans1544053_frypans
gardant9314463gard_ant
gardens93312093gard_ens
guardians1143913guardians
habitans1346623habitans
hadrons113314303ha_drons
hagdons1258523hagd_ons
hairpins1365433hairpins
handbags15116363handbags
handcars1437623handcars
handguns1344363handguns
handsaws1545873handsaws
hanumans1344953hanumans
happens14359173ha_ppens
harass9313943har__ass
hardback2045633hardback
hardbacks2145373hardbacks
hardball14116303hardball
hardballs15115543hardballs
hardcase1445623hardcase
harden105718533hard_en_
hardhack2143843hardhack
hardhacks2243703hardhacks
hardhat14411023hardha_t
hardheads1745773hardheads
hardies114923233hard_ies
hardline12310273hardline
hardness122411083hardness
hards96435653hard___s
hardstand1444473hardstand
hardstands1543663hardstands
hardtack1843993hardtack
hardtacks1943803hardtacks
hardtops1444843hardtops
hardware1546283hardware
hardwares1646563hardwares
hariana10310243har_iana
harianas1139163har_ianas
harijan1735783harijan_
harkens144112863har_kens
harmins123716723har_mins
harpers124916203har_pers
harpies123818313har_pies
harpin113614383har_pin_
harping134118383har_ping
harpings14379773har_pings
harpoons1337483harpoons
harps105926873har_p__s
harridans13154563harridans
harshens1437603harshens
hartals10313023har_tals
hatpins123410643ha_tpins
hazans183411653ha__zans
hazzans18215783ha_zzans
headpins1436103headpins
herdman13238423herdman_
hordeins1238323hordeins
japans1539823ja__pans
jordans1566833jord_ans
lardons83914493lard_ons
lardoons9398483lardoons
lurdans837073lurd_ans
martians103111613martians
marzipans2242643marzipans
pardahs13289673pard_ahs
pardons103817623pard_ons
parians93519733par_ians
partans94418283par_tans
radians83013823ra_dians
randans8313213rand_ans
saltpans1034813saltpans
sampans112411003sa_mpans
sarans64224433sar__ans
sardana838643sard_ana
sardanas937813sard_anas
sardars83112903sard_ars
sharpens13377813shar_pens
taipans9269553ta_ipans
tampans113310983ta_mpans
tardyons1244613tardyons
tarpan82814293tar_pan_
tarpons92612213tar_pons
tartans72615823tar_tans
tarzans16329923tar_zans
trapans92812463_trapans
trepans92311593_trepans
wardens113711903ward_ens
yardland1343763yardland
yardlands1443583yardlands
yardman1335913yardman_
yardwand1642743yardwand
yardwands1742683yardwands

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.406440125.6
2DLD Change Limit1461621176.68621860.9
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.13825033.8
 
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.