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

111 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
hairpin124541(None) 
hairpins1365431hairpins
harpin113614381ha_rpin
hairline1137872hairline
harmin113117392ha_rmin
harping134118382ha_rping
harpins123615702ha_rpins
hatpin112610612ha_tpin
airing74927503_air_ing
airline7315033_airline
airman82414223_airman
airmen82612353_airmen
airn46433833_air__n
airting83616303_airting
arpen74418043_a_rpen
atropin9311583_atropin
bairn77515533bair__n
cairn75717513cair__n
carlin84421823ca_rlin
carpi94319393ca_rpi_
carping123521083ca_rping
chagrin1337893chagr_in
chairing143110773chair_ing
chairman15106383chairman
chairmen15105473chairmen
chirping16278863chirping
dairying1336353dairying
fairing113614013fair_ing
firkin1337823_firkin
gaijin1445983gai_jin
hadron102913753hadr_on
haemin113412663ha_emin
hailing113820693hai_ling
hair76330143hair___
hairband1444573hairband
haircap14134753haircap
haircut1246833haircut
hairdo1036433hair_do
hairdos1136823hairdos
haired105117173hair_ed
hairier103111053hairier
hairlike1536673hairlike
hairlines1237133hairlines
hairnet10911703hairnet
hairpiece1642333hairpiece
hairs86225173hair__s
hairspring1643303hairspring
hairy115316833hair__y
happen134812193ha_ppen
happing153817233ha_pping
harden105718533ha_rden
hardpan1336443hardpan
harijan1735783harijan
haring104233003ha_r_ing
harken135116343ha_rken
harking154120943ha_rking
harmine122816193ha_rmine
harming133717933ha_rming
harmins123716723ha_rmins
harp96134293ha_rp__
harped124418403ha_rped
harper115018403ha_rper
harpies123818313ha_rpies
harpings14379773ha_rpings
harpist12312353ha_rpist
harpoon1238313ha_rpoon
harps105926873ha_rp_s
harpy136418213ha_rp_y
harrying15157643harrying
hasping134414903ha_sping
hatpins123410643ha_tpins
headpin1336003headpin
heiring113312903heir_ing
herein93717793h_erein
heroin94420593h_eroin
hippie132811243h_ippie
hipping153915103h_ipping
hircine1239143h_ircine
hiring104421603h_ir_ing
hirple11158973h_irple
hirpling1467223h_irpling
hirudin1144753h_irudin
hispid1238173h_ispid
huipil1143773hui_pil
jalapin1645923jalapin
lairing83715343lair_ing
lapin75222923la__pin
lipin75518893_li_pin
margin94016843ma_rgin
marlin84220903ma_rlin
martin84122523ma_rtin
mirin75023153_mir_in
orpin73415533__orpin
pairing103716733pair_ing
pippin92810303_pippin
raisin62716923rai_sin
saimin8313663sai_min
sarin55239253sa_r_in
shairn9269063shair__n
sharpen12389723sha_rpen
sharpie1238393sha_rpie
sharping143011373sha_rping
tailfin1035693tailfin
tailspin1043763tailspin
taipan82410663tai_pan
tarpan82814293ta_rpan
tarpon82812803ta_rpon
tiepin839343_tiepin
virgin1038083_virgin
wairing113414313wair_ing
warping133715183wa_rping

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.390458182.1
2DLD Change Limit1340271117.17318684.9
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.60923484.2
 
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.