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

209 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
unhair93733(None) 
unchair1236161unchair
unfair936231unfair
unhairs1036371unhairs
chair105519632_chair
funfair1342032funfair
hair76330142__hair
mohair1135202mohair
unai44824782un_ai_
unais53420772un_ais
unbar71913612unba_r
unchain1238942unchain
unchairs1345502unchairs
unhaired12238762unhaired
unhairer11174992unhairer
unhand10410382unhand
unhang1038442unhang
unhat81119262unha_t
unhats91110622unhats
unhip10178822unh_ip
unlaid7311752unlaid
unnail6410582unnail
unpaid939472unpaid
unsaid7411832unsaid
affair1234353affair
air38058393___air
anear55420323anea_r
antiair7310313antiair
antiar6317173antiar
chai95929903_chai_
chain105723673_chain
chairs114916183_chairs
chais107530313_chais
char95132153_cha_r
charr104821783_charr
choir105313603_choir
cochair1446313cochair
coheir1137583coheir
deair65817193_deair
eclair836813eclair
enchain1248863enchain
enhalo987563enhalo
entail61114343entail
fair76332523__fair
flair86114123_flair
funfairs1442133funfairs
glair65313553_glair
gnar56021383gn_a_r
gnarr64810693gn_arr
haar77323493__haar
haik115526983__haik
hail74839063__hail
hairs86225173__hairs
hairy115316833__hairy
heir77523803__heir
impair1036003impair
inhabit1277403inhabit
inhale9411513inhale
inhaler1068053inhaler
inhaul936803inhaul
inlaid7310143inlaid
invar839513inva_r
knar85818723kn_a_r
knaur9508253kn_aur
lahar83114263laha_r
lair45934153__lair
longhair1242673longhair
lunar57017313lun_a_r
mair66133783__mair
menhir1136783menh_ir
midair937993midair
mohairs1234953mohairs
nadir61012973_nadir
naif76839023_n_aif
nail45838653_n_ail
naira5314743_n_aira
nairu5413813_n_airu
near45236503_nea_r
noir46722433_n_oir
pair66031513__pair
repair84011463repair
shaird10288703_shaird
shairn9269063_shairn
snail57020203sn_ail
stair54719943_stair
thairm1156963_thairm
their85512153_their
thir76420543_th_ir
uakari1046863uakari
ulnar56013983ulna_r
unaired82916013un_aired
unakin10310963unakin
unapt710421593un_apt
unarm7314453un_arm
unary8315993un_ary
unau43924153un_a_u
unaus53216573un_aus
unbale83616403unbale
unban72114333unba_n
unbans81912623unbans
unbars82113033unbars
unbear889163unbear
unbid83214643un_bid
unbraid1037183unbraid
uncage93014873uncage
uncake122813523uncake
uncap9312283unca_p
uncaps1039813uncaps
uncase83817433uncase
uncast84215713uncast
unchains1338303unchains
unchaired1536203unchaired
unchary1537263unchary
unchic1338643unchic
unci65019463un_ci_
uncia75015163un_cia
unciae83215313unciae
uncial83715223uncial
unclip1046993unclip
uncoil8811853uncoil
under64624213un_der
underhair1345733underhair
undid72415363un_did
undoer73113043undoer
uneager839753uneager
unease63816643unease
uneasier836963uneasier
uneasy9278853uneasy
unfairer11184283unfairer
unfairly1443563unfairly
unfaith1345783unfaith
unfit84518563un_fit
unfix15429033un_fix
ungird887973un_gird
ungirt71112713un_girt
unguis738453unguis
unhailed12219963unhailed
unhairers12183273unhairers
unhairing1335953unhairing
unhandier1344883unhandier
unhands1137773unhands
unhandy1445513unhandy
unhangs1136203unhangs
unhappier1642403unhappier
unhappy1742803unhappy
unhasty1344283unhasty
unheard1136943unheard
unhelm1136863unhelm
unhewn12285253unhewn
unhired112512153unh_ired
unholier1137283unholier
unholy1238163unholy
unhood1039233unhood
unhook1347523unhook
unhung1035283unhung
unhurt9311253unhurt
unhusk1334263unhusk
unific1137463unific
unifier102211863unifier
unit45140073un__it
uniter64619143uniter
unjam1448723unja_m
unjams1555703unjams
unknit1068593unknit
unlace82215173unlace
unlade72714153unlade
unlash938793unlash
unlay84613703unla_y
unlays93810493unlays
unlit55025463un_lit
unmade92911063unmade
unmake122811213unmake
unmaker13279513unmaker
unman72715423unma_n
unmans82211993unmans
unmask1265903unmask
unmix14388973un_mix
unmoor836313unmoor
unnails738223unnails
unpack1457833unpack
unpaired11208943unpaired
unpin72613243un_pin
unplait948603unplait
unrepair1042373unrepair
unrig61711413un_rig
unrip72012863un_rip
unsafe9310693unsafe
unsawn9317463unsawn
unsay83212843unsa_y
unsays9399543unsays
unsharp1235543unsharp
unship1148033unship
untack1239763untack
untame82513603untame
untie54425493un_tie
until53517743un_til
untrim8310683untrim
unveil957343unveil
unwarier1136883unwarier
unwary1239823unwary
unwit84417523un_wit
unzip16207623un_zip
upstair943983upstair
upstir835383upstir
urari54619963u_rari
usher84517763ush_er
vair75624143__vair
wair75830053__wair
whir105519283_wh_ir

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162095.29621283.2
3Display Results2092090.0802612.5
 (SQL Overall)1786912095.74931082.1
 
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.