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

188 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
hairnet1091170(None) 
hairnets1195631hairnets
cairned1037642cairned
carnet84732872ca_rnet
garnet73928412ga_rnet
haint85436322hai_n_t
haircut1246832haircut
haired105117172hair_ed
hairier103111052hairier
hairiest11612472hairiest
hornet94926432h_ornet
afreet9315153_afreet
aiglet74224193_aiglet
aigret73720023_aigret
aired66032923_air_ed
airer54927893_air_er
airest63825263_airest
airier64619363_airier
airiest74221013_airiest
airmen82612353_airmen
airn46433843_airn__
airns55521033_airn_s
airt45757793_air__t
airted74214503_airted
armet76739463_a_rmet
bairn77515533bairn__
bairnly1234503bairnly
bairns86710873bairn_s
bannet84925333ba_nnet
barbet104427883ba_rbet
barned95623583ba_rned
barney115314453ba_rney
baronet91022213baronet
barret84930493ba_rret
basinet9318933basinet
bayonet121212213bayonet
beignet101510963beignet
burnet84326173_burnet
cabernet12410763cabernet
cabinet11318903cabinet
cairn75717513cairn__
cairns85313303cairn_s
cairny11557823cairn_y
caret75360563ca_r_et
carnets93918403ca_rnets
carney115315703ca_rney
carpet104530093ca_rpet
chaine115119223chai_ne_
chained133812693chai_ned
chaines124518733chai_nes
chaired134211243chair_ed
chairmen15105473chairmen
charnel124010053cha_rnel
clarinet10317293clarinet
cornet84436733_cornet
dairies84217733dairies
darned85018483da_rned
darnel74312183da_rnel
darner74017303da_rner
dipnet91317473_dipnet
earned74818333ea_rned
earner63617223ea_rner
earnest7318733ea_rnest
fainer94717243fai_ner
fainest10417703fai_nest
faint85837063fai_n_t
faired105915773fair_ed
fairer95212063fair_er
fairest10412293fairest
fairies103516043fairies
fairness1136563fairness
gained84617463gai_ned
gainer74117493gai_ner
gainst74914703gai_nst
gannet74321853ga_nnet
garget84327273ga_rget
garner73917003ga_rner
garnets84115413ga_rnets
garret74426563ga_rret
girned84010513_girned
gurnet74920873_gurnet
hackney1935123hackney
haeres94017033haer_es
haet75659503ha___et
haffet15311703ha_ffet
hailed104122743hai_led
hailer94720343hai_ler
haints94417583hai_nts
hair76330143hair___
haircap14134753haircap
haircuts1343663haircuts
hairdo1036433hair_do
hairdos1136823hairdos
hairiness1238013hairiness
hairless1157413hairless
hairline1137883hairline_
hairlines1237143hairlines
hairpin1245413hairpin
hairs86225173hair__s
hairy115316833hair__y
hamlet113722793ha_mlet
handset113016823handset
hangnest12311413hangnest
hant75461593ha__n_t
harden105718533ha_rden
harder105022403ha_rder
hardest113118413ha_rdest
hardset113415833hardset
hare76255733ha_r_e_
hared95742183ha_r_ed
hareem114312063ha_reem
harem104924453ha_r_em
hares86255543ha_r_es
haricot12311963haricot
haring104233003harin_g
harked145422553ha_rked
harken135116343ha_rken
harlot94422803ha_rlot
harmed125218843ha_rmed
harmer114719563ha_rmer
harness102413933ha_rness
harped124418403ha_rped
harper115018403ha_rper
harried113815543harried
harrier104417763harrier
harries103525503harries
harslet10315653harslet
hart76865773ha_r__t
harvest132112753ha_rvest
haslet93222713ha_slet
hatchet153317563hatchet
hatred104814333hatr_ed
haunt85229133ha_un_t
havened14429243havened
heired103813043heir_ed
hint77455753h_i_n_t
hire75538973h_ir_e_
hired95226263h_ir_ed
hiree85427803h_ir_ee
hirees95117293h_irees
hirer85423123h_ir_er
hires86134343h_ir_es
hirsel9138683h_irsel
horned105718703h_orned
hornets104113553h_ornets
horrent10313553horrent
jaconet16311483jaconet
kainit10414483kai_nit
kirned11408623_kirned
labret8320223labr_et
laired75216813lair_ed
larine63927053larine_
linnet6419423_linnet
magnet9320663ma_gnet
marine84230423marine_
mariner93316013mariner
marines93928043marines
market123226043ma_rket
nailset7311973nailset
narine63422563narine_
pained95622853pai_ned
paint75443693pai_n_t
paired95017523pair_ed
parent83230423pa_rent
parget94529393pa_rget
raiment9315413raiment
rained75024603rai_ned
sained75424243sai_ned
saint55147073sai_n_t
sarsnet7314813sarsnet
satinet7325283satinet
shairn9269063shairn__
shairns10276783shairn_s
signet73621153_signet
skirret11278173skirret
spinet85629753spi_net
taint55542283tai_n_t
target75028913ta_rget
vainer93714573vai_ner
vainest10315763vai_nest
varlet9423503va_rlet
waired106015833wair_ed
warned104018913wa_rned
warner93717223wa_rner
yarned105514023ya_rned
yarner93313063ya_rner
zaire14311993zair_e_
zaires1539703zair_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 Filter1786911340270.423422437.4
2DLD Change Limit1340271886.98319193.3
3Display Results1881880.0632984.1
 (SQL Overall)1786911887.46923924.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.