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

124 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
headpin133600(None) 
headpins1436101headpins
deadpan11225232deadpan
harpin113614382h_arpin
hatpin112610612h_atpin
heading122919112head_ing
headline12129612headline
headman13229632headman
headmen13259512headmen
headwind1643872headwind
heaping133015852hea_ping
beading113221863bead_ing
beadman12249153beadman
beadmen12299453beadmen
bedpan1137583be_dpan
beduin939713be_duin
cheapen14407623chea_pen
cheapie1437563chea_pie
deaden83714323dead_en
deadline10139053deadline
deadman11238423deadman
deadmen11248573deadmen
deadpans12205173deadpans
endrin7312403_endrin
fadein1068843_fadein
gradin83517483grad_in
hading113922943h_ad_ing
hadji16839893h_adji_
hadjis17439653h_adjis
hadron102913753h_adron
haemin113412663h_aemin
hairpin1245413hairpin
happen134812193h_appen
happing153817233h_apping
hardpan1336443hardpan
harmin113117393h_armin
harping134118383h_arping
harpins123615703h_arpins
hasping134414903h_asping
hatpins123410643h_atpins
head87137173head___
headband1544843headband
headed114020473head_ed
headend12398363headend
header104422543head_er
headers113819393headers
headfish1845443headfish
headful1445563headful
headhunt1544693headhunt
headier113212953headier
headily1478623headily
headings133510493head_ings
headland1345613headland
headlined14135133headlined
headliner13135393headliner
headlines13119013headlines
headlong1334123headlong
headphone18124733headphone
headpiece1742803headpiece
heads95127113head__s
headsail1244423headsail
headset11312603headset
headship1745743headship
headsman1446353headsman
headsmen1465983headsmen
headspring17133243headspring
headway1745553headway
headwinds1743153headwinds
heady125117263head__y
healing113922963hea_ling
heap96432893hea_p__
heaped124516903hea_ped
heaper114119523hea_per
heaps105223223hea_p_s
heapy135914983hea_p_y
hearing113324163hea_ring
hearken14338023hearken
hearsing1239383hearsing
hearten102411753hearten
hearting12513123hearting
heathen133410893heathen
heating114024323hea_ting
heaven123912603hea_ven
heaving144114763hea_ving
hedging13348953he_dging
heeding123515063heed_ing
helping133512223he_lping
hematein1387013hematein
hematin121516023hematin
hemin103620933he__min
hempen1338963he_mpen
hempie132410563he_mpie
heparin12410433heparin
herdic123112303herd_ic
herding122915123herd_ing
herdman13238423herdman
herdmen13238453herdmen
herein93717793he_rein
heroin94420593he_roin
hexadic2045413hexad_ic
hoatzin1943943hoatzin
hoddin11369943h_oddin
hordein1138753hordein
hyalin122210043hya_lin
lapin75222923_la_pin
leaden74515223lead_en
leading93419553lead_ing
leadman10237843leadman
leadmen10277903leadmen
leaping103215993lea_ping
readding11411363readding
reading93327213read_ing
readmit1039823readmit
readorn8310483readorn
readying13410223readying
reagin74915533rea_gin
reaping103621213rea_ping
redfin10310223re_dfin
repin75324703re__pin
tenpin8310583te_npin
threadfin1641953threadfin
verdin103113023verd_in
weapon11288113wea_pon
zeatin15412823zea_tin

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.406440125.6
2DLD Change Limit1340271246.92319359.7
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.37524229.3
 
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.