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

147 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
hairnets119563(None) 
hairnet10911701hairnet_
carnets93918402ca_rnets
fairness1136562fairness
garnets84115402ga_rnets
haints94417582hai_n_ts
haircuts1343662haircuts
hairiest11612462hairiest
hairiness1238012hairiness
hairless1157412hairless
harness102413932ha_rness
hornets104113552h_ornets
afreets1037013_afreets
aiglets84012913_aiglets
aigrets82810533_aigrets
airers64922313_air_ers
airest63825263_air_est
airiest74221013_airiest
airiness8412213_airiness
airless73712043_airless
airns55521033_airn__s
airts55626343_air__ts
armets84918353_a_rmets
bairns86710873bairn__s
bannets94013843ba_nnets
barbets114915843ba_rbets
barneys12569563ba_rneys
baronets101410903baronets
barrets94917103ba_rrets
basinets1039063basinets
bayonets13135583bayonets
beignets11155373beignets
burnets93813263_burnets
cabernets1345063cabernets
cabinets1238283cabinets
cairned1037643cairne_d
cairns85313303cairn__s
carets85330773ca_r_ets
carnet84732873ca_rnet_
carneys124310543ca_rneys
carpets113915333ca_rpets
chaines124518733chai_ne_s
chariness14310063chariness
charnels13328173cha_rnels
clarinets1137683clarinets
cornets94820573_cornets
dairies84217733dairie_s
darnels83710433da_rnels
darners83815773da_rners
dipnets10109033_dipnets
earners74016453ea_rners
earnest7318733ea_rnest
earnests837853ea_rnests
fainest10417703fai_nest
faints94818783fai_n_ts
fairest10412293fair_est
fairies103516043fairie_s
farness102912203fa_rness
gainers84214593gai_ners
gannets83811443ga_nnets
gargets94614573ga_rgets
garners83815983ga_rners
garnet73928413ga_rnet_
garrets84413623ga_rrets
gurnets84010793_gurnets
hackneys2033683hackneys
haeres94017033haer_e_s
haets86525123ha___ets
haffets1636053ha_ffets
hailers104017263hai_lers
haint85436323hai_n_t_
haircaps15144363haircaps
haircut1246833haircut_
hairdos1136823hair_dos
haired105117173hair_e_d
hairier103111053hairie_r
hairlines1237133hairline_s
hairpins1365433hairpins
hairs86225173hair___s
haleness11312623haleness
halfness1435563halfness
hamlets123211403ha_mlets
handsets12258343handsets
hangnest12311413hangnest
hangnests1344543hangnests
hants86335403ha__n_ts
hardens113815023ha_rdens
hardest113118413ha_rdest
hardness122411083hardness
hareems12428203ha_reems
harems115513823ha_r_ems
hares86255543ha_r_e_s
haricots1347333haricots
harkens144112863ha_rkens
harlots103413293ha_rlots
harmers124116593ha_rmers
harpers124916203ha_rpers
harriers113712433harriers
harries103525493harrie_s
harslets1137833harslets
harts88441593ha_r__ts
harvest132112753ha_rvest
harvests14246173ha_rvests
haslets102510863ha_slets
hatchets163310383hatchets
hatreds11307813hatr_eds
haunts95614393ha_un_ts
haziness20248513haziness
heiress1036813heir_ess
heirless1146053heirless
hints87330623h_i_n_ts
hipness12277383h_ipness
hirees95117293h_ir_ees
hirers94518063h_ir_ers
hires86134343h_ir_e_s
hirsels10128343h_irsels
hoariness1238823hoariness
hornet94926433h_ornet_
jaconets1745613jaconets
kainits1137763kai_nits
labrets939363labr_ets
linnets739833_linnets
magnets10311143ma_gnets
mariners103113863mariners
marines93928013marine_s
markets133314033ma_rkets
nailsets834553nailsets
paints85921833pai_n_ts
parents93418123pa_rents
pargets105215193pa_rgets
raiments1039903raiments
saints65122423sai_n_ts
sarsnets836783sarsnets
satinets8311733satinets
shairns10276783shairn__s
signets83311503_signets
skirrets12244003skirrets
spinets94714813spi_nets
taints64520533tai_n_ts
targets84314223ta_rgets
vainest10315763vai_nest
vainness1136063vainness
varlets10411573va_rlets
wariness11313213wariness
warners103315563wa_rners
yarners104312203ya_rners
zaires1539703zair_e_s

Search took 9 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.186960704.3
2DLD Change Limit1461621478.12617987.0
3Display Results1471470.0463195.7
 (SQL Overall)1786911478.35821379.6
 
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.