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 “hairlines” 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
hairlines123713(None) 
airlines8312791_airlines
hairline1137871hairline_
airline7315032_airline_
airliner836952_airliner
airliners945982_airliners
carlines103521642ca_rlines
hairiness1238012hair_iness
hairlike1536672hairlike_
hairpins1365432hairpin_s
harmines132715142ha_rmines
hiplines13310592h_iplines
mainlines1138512mainlines
marlines103818712ma_rlines
aiblins9311473_aiblin_s
airiness8412213_air_iness
airings83913843_air_ings
airlifts1143633_airlifts
airlike11310333_airlike_
airplanes1187233_airplanes
airtimes1037503_airtimes
alines65735223_a__lines
anilines8415143_anilines
arsines73518813_a_rsines
bailies94120203bai_li_es
balklines1536743balklines
baselines1138603baselines
berlines102315453_berlines
birlings11359613_birlings
carbines123617533ca_rbines
carline93923613ca_rline_
carlings114015853ca_rlings
carlins93921913ca_rlin_s
carmines123617863ca_rmines
chairlifts1851313chairlifts
charlies133414233cha_rli_es
dailies84219263dai_li_es
dailiness1038673dai_liness
dairies84217733dair_i_es
dairyings1442633dairyings
darlings103710383da_rlings
datelines1088853datelines
earliness939693ea_rliness
failings123811013fai_lings
fairies103516043fair_i_es
fairings12388193fair_ings
gantlines1039333gantlines
gasolines1047483gasolines
girlies83013703_girli_es
hagrides1337623hagr_ides
hailing113820693hai_lin_g
hairbands1544063hairbands
hairier103111053hair_i_er
hairiest11612463hair_i_est
hairless1157413hairl_ess
hairlocks1863773hairlocks
hairnet10911703hair__net
hairnets1195633hair__nets
hairpieces1752043hairpieces
hairpin1245413hairpin__
halflives1842783halflives
halides113416663ha__lides
halites103221193ha__lites
haloclines1544213haloclines
handlings14237343handlings
haplites1339993ha_plites
hardies114923233ha_rdi_es
hardiness132310353ha_rdiness
hardline12310273hardline_
harmine122816193ha_rmine_
harmins123716723ha_rmin_s
harpies123818313ha_rpi_es
harpings14379773ha_rpings
harpins123615703ha_rpin_s
harries103525493ha_rri_es
hayrides1536883hayr_ides
headlines13119013headlines
heliclines1544043heliclines
hemlines13310623h_emlines
heroines112916573h_eroines
hilliness1248923h_illiness
hipline12311423h_ipline_
hircine1239143h_ircine_
hirelings1365763h_irelings
hotlines11811643h_otlines
hourlies1138343hourli_es
hurlies103315333h_urli_es
hurlings12388213h_urlings
hyalines14169333h_yalines
jawlines18126363ja_wlines
kaolines1239293ka_olines
landlines1039763landlines
lanolines939983lanolines
latrines8515003latr_ines
mailings113011923mai_lings
mainline1039863mainline_
mainlined1254353mainlined
mainliner1144673mainliner
mainliners1244003mainliners
malines93625603ma__lines
marines93928013ma_r_ines
marline93320953ma_rline_
marlings113713493ma_rlings
marlins93420473ma_rlin_s
marlites103415263ma_rlites
midlines112613333_midlines
millines102718063_millines
pairings11398313pair_ings
purlines103514053_purlines
railings93412153rai_lings
ratlines83815293ra_tlines
sailings93513253sai_lings
salines74029413sa__lines
sardines92815563sa_rdines
tacrines10310563tacr_ines
taglines92210833ta_glines
tailings93211673tai_lings
tapelines1138463tapelines
taurines8310553taur_ines
valines104520213va__lines
vaselines1246713vaselines
waistlines1343893waistlines
waterlines1348953waterlines
whirlies14167373whirli_es

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411246.78321913.8
3Display Results1241240.0602066.7
 (SQL Overall)1786911247.27924548.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.