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

116 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
hairpins136543(None) 
hairpin1245411hairpin_
harpins123615701ha_rpins
hairline1137872hairline
hairlines1237132hairlines
harmins123716722ha_rmins
harpies123818312ha_rpies
harpin113614382ha_rpin_
harping134118382ha_rping
harpings14379772ha_rpings
hatpins123410642ha_tpins
aiblins9311473_aiblins
airing74927503_air_ing
airings83913843_air_ings
airline7315033_airline
airlines8312793_airlines
airns55521033_air__ns
airting83616303_airting
arpens84814823_a_rpens
atropins10410493_atropins
bairns86710873bair__ns
cairns85313303cair__ns
carlins93921913ca_rlins
carping123521083ca_rping
carpings133812383ca_rpings
chagrins1437073chagr_ins
chairing143110773chair_ing
chairmans1685143chairmans
chirping16278863chirping
dairies84217733dair_ies
dairying1336353dairying
dairyings1442633dairyings
fairies103516043fair_ies
fairing113614013fair_ing
fairings12388193fair_ings
firkins1437663_firkins
hadrons113314303hadr_ons
haemins122811403ha_emins
hailing113820693hai_ling
hairband1444573hairband
hairbands1544063hairbands
haircaps15144363haircaps
haircuts1343663haircuts
hairdos1136823hair_dos
hairier103111053hair_ier
hairiest11612463hair_iest
hairiness1238013hair_iness
hairless1157413hairless
hairlike1536673hairlike
hairnets1195633hairnets
hairpiece1642333hairpiece
hairpieces1752043hairpieces
hairs86225173hair___s
hairspring1643303hairspring
hairsprings1752203hairsprings
happens14359173ha_ppens
happing153817233ha_pping
hardens113815023ha_rdens
hardies114923233ha_rdies
hardpans1436453hardpans
harijans1845723harijans
haring104233003ha_r_ing
harkens144112863ha_rkens
harking154120943ha_rking
harmin113117393ha_rmin_
harmine122816193ha_rmine
harmines132715143ha_rmines
harming133717933ha_rming
harpers124916203ha_rpers
harpist12312353ha_rpist
harpists1338103ha_rpists
harpoons1337473ha_rpoons
harps105926863ha_rp__s
harries103525493ha_rries
harrying15157643harrying
hasping134414903ha_sping
hatpin112610603ha_tpin_
headpins1436103headpins
heiring113312903heir_ing
heroins103518013h_eroins
hippies142813743h_ippies
hipping153915103h_ipping
hircine1239143h_ircine
hiring104421603h_ir_ing
hirples12149643h_irples
hirpling1467223h_irpling
hirudins1244933h_irudins
huipils1243533hui_pils
jalapins1745623jalapins
lairing83715343lair_ing
lapins84520683la__pins
lipins85016883_li_pins
margins103815193ma_rgins
marlins93420473ma_rlins
martins93322063ma_rtins
mirins83918903_mir_ins
orpins83614163__orpins
pairing103716733pair_ing
pairings11398313pair_ings
pippins10319753_pippins
raisins72715343rai_sins
saimins9312113sai_mins
sarins63932623sa_r_ins
shairns10276783shair__ns
sharpens13377813sha_rpens
sharpies13411223sha_rpies
sharping143011373sha_rping
tailfins1135443tailfins
tailspins1143603tailspins
taipans9269553tai_pans
tarpans92513533ta_rpans
tarpons92612203ta_rpons
tiepins939463_tiepins
virgins1137863_virgins
wairing113414313wair_ing
warping133715183wa_rping

Search took 10 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 Limit1461621169.01316216.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911169.37219066.5
 
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.