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

297 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
hairless115741(None) 
airless73712041_airless
heirless1146051heirless
aidless83612072_aidless
aimless93610812_aimless
barless94317002ba_rless
carless95118492ca_rless
earless74316072ea_rless
fairness1136562fairness
gainless9117402gainless
hailers104017262hai_lers
hairiest11612462hairiest
hairiness1238012hairiness
hairnets1195632hairnets
haltless11308442haltless
handless123512062handless
hapless123311332ha_pless
harmless1337402harmless
harness102413932ha_rness
hatless103813442ha_tless
heiress1036812heir_ess
hipless12399922h_ipless
hitless103211192h_itless
mailless10248582mailless
oarless73913372oa_rless
painless10108342painless
rainless8129702rainless
sailless82410362sailless
stairless9185622stairless
tailless8239082tailless
warless104015102wa_rless
ageless8310343_ageless
aiglets84012913_aiglets
airers64922313_air_ers
airest63825263_air_est
airiest74221013_airiest
airiness8412213_airiness
aisles64721143_aisle_s
arles56735743_a_rle_s
armless9369943_armless
artless73712513_artless
ashless10318453_ashless
aweless1038723_aweless
awless939263_a_wless
awnless1035923_awnless
backless162910633backless
bailees93914383bai_lees
bailers94221353bai_lers
baileys12388933bai_leys
barbless12318713barbless
barkless14318023barkless
barleys125011843ba_rleys
baseless1099563baseless
bathless13127383bathless
bibless11439173_bibless
birlers93813003_birlers
birles84920643_birle_s
brainless1136403brainless
brimless1235273brimless
capless114312763ca_pless
careless102813633careless
caress85720263ca_r_ess
carles85435083ca_rle_s
cashless1336773cashless
chadless1436403cha_dless
chariness14310063chariness
charleys1695633cha_rleys
charmless1633573charmless
chartless1435703chartless
cheerless1495293cheerless
chinless1337493chinless
dairies84217733dairie_s
dateless9259963dateless
doorless936713doorless
dripless1135243dripless
exitless1534883exitless
faceless13269173faceless
fadeless12258323fadeless
failles102914133faille_s
fairest10412293fair_est
fairies103516043fairie_s
fairlead1243513fairlead
fairleads1343023fairleads
faithless1543903faithless
fameless13259203fameless
fangless1237663fangless
farles96025783fa_rle_s
farness102912203fa_rness
fatless103212203fa_tless
fearless1137873fearless
finless102810783_finless
fireless112810593_fireless
furless103210143_furless
gapless10349993ga_pless
garbless11388253garbless
gasless8319013ga_sless
gateless9279953gateless
gearless937373gearless
grainless1035883grainless
hacklers173710303hacklers
hackles162917063hackle_s
haeres94017033haer_e_s
hagglers13326623hagglers
haggles123312483haggle_s
hailed104122743hai_le_d
hailer94720343hai_le_r
hails85231643hai_l__s
haircaps15144363haircaps
haircuts1343663haircuts
hairdos1136823hair_dos
haired105117173hair_e_d
hairier103111053hairie_r
hairlike1536673hairlike
hairline1137873hairline
hairlines1237133hairlines
hairlock1754023hairlock
hairlocks1863773hairlocks
hairnet10911703hairne_t
hairpins1365433hairpins
hairs86225173hair___s
haleness11312623haleness
halers94926913ha__lers
hales85449843ha__le_s
halest94823273ha__lest
halfness1435563halfness
hallels103310133ha_llels
hamlets123211403ha_mlets
hammerless1742363hammerless
handlers124014143handlers
handles114020653handle_s
hantles104117513hantle_s
haoles94919803ha_ole_s
harass9313943ha_r_ass
harborless1542663harborless
hardass1139753ha_rdass
hardens113815023ha_rdens
hardest113118413ha_rdest
hardness122411083hardness
hareems12428203ha_reems
harems115513823ha_r_ems
hares86255543ha_r_e_s
harkens144112863ha_rkens
harlots103413293ha_rlots
harls85634503ha_rl__s
harmers124116593ha_rmers
harpers124916203ha_rpers
harriers113712433harriers
harries103525493harrie_s
harslets1137833harslets
harvest132112753ha_rvest
harvests14246173ha_rvests
haslets102510863ha_slets
hassles103411693hassle_s
hatreds11307813hatr_eds
haulers104012443ha_ulers
haziness20248513haziness
headless12289863headless
heartless1236393heartless
heathless1535593heathless
heatless113011463heatless
heedless12278813heedless
heelless11257653heelless
helmless1334273helmless
helpless1335063helpless
herbless1336663herbless
hideless12278713hideless
hillers103718723h_illers
hiltless11297123hiltless
hipness12277383h_ipness
hirees95117293h_ir_ees
hirers94518063h_ir_ers
hires86134343h_ir_e_s
hirples12149643h_irple_s
hirsels10128343h_irsels
hirsles101510073h_irsle_s
hiveless14227933hiveless
hoariness1238823hoariness
holeless1189363holeless
homeless131110133homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279253hoopless
hopeless13118303hopeless
hornless1137363hornless
hueless1058823h_ueless
humorless1442963humorless
humpless15226333humpless
hurlers103714323h_urlers
hurleys13407333h_urleys
hurtless11307783hurtless
hymnless1632803hymnless
ireless72312243__ireless
jagless1537103ja_gless
jailers144114043jai_lers
jawless1745653ja_wless
kinless113310273_kinless
kirmess13234313_kirmess
laceless10239853laceless
landless94011173landless
largess8408913la_rgess
lawless1037033la_wless
lidless8309273_lidless
lipless9259553_lipless
mailers94420333mai_lers
mailes84329113mai_le_s
maneless102812343maneless
manless93012933ma_nless
massless10277113massless
mastless102610023mastless
mateless102711293mateless
matless93014043ma_tless
nailers73215893nai_lers
nameless10248373nameless
napless93110283na_pless
nathless11127023nathless
odorless934173odorless
paisleys1333343paisleys
paneless102611763paneless
paperless1345833paperless
parles86334403pa_rle_s
parleys125212373pa_rleys
passless10247223passless
pastless102411203pastless
pathless13138043pathless
peerless1037513peerless
railers74420663rai_lers
rankless12268233rankless
rayless10239003ra_yless
reinless8139433reinless
ribless93410343_ribless
rimless9369363_rimless
sailers73822313sai_lers
saltless8259343saltless
sandless93212343sandless
sapless93313443sa_pless
sashless1136603sashless
savorless1243213savorless
scarless10189053scarless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
shipless13277693shipless
shirtless12266413shirtless
shitless11249243shitless
sinless73014213_sinless
skilless12246753skilless
skinless12216973skinless
skirtless13254423skirtless
slipless10246993slipless
slitless8268143slitless
soilless8279023soilless
spinless10238703spinless
stainless9176493stainless
starless81610843starless
tackless14419483tackless
tactless10288463tactless
tailers73720183tai_lers
tailles72516473taille_s
taintless935733taintless
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
taxless1436903ta_xless
tearless848713tearless
thankless1633203thankless
thawless1434083tha_wless
tieless72512563_tieless
tipless92610063_tipless
tireless82510263_tireless
trailless935963trailless
twigless1293663twigless
twirlers11274303twirlers
vainness1136063vainness
vaporless1443163vaporless
varlets10411573va_rlets
veinless11136263veinless
wageless1237173wageless
wailers103916803wai_lers
waistless1235093waistless
waitress1135223waitress
wakeless1536473wakeless
wardless12249303wardless
wariness11313213wariness
wartless11279923wartless
waterless1238013waterless
wattless11268723wattless
waveless1437483waveless
wayless13308243wa_yless
weariless1234763weariless
whirlers14286053whirlers
wigless11359673_wigless
winless103212283_winless
wireless11249633_wireless
witless103310983_witless
zaires1539703zair_e_s
zipless18276303_zipless

Search took 7 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.1531167915.0
2DLD Change Limit1461622976.53322372.9
3Display Results2972970.1102700.0
 (SQL Overall)1786912976.79626293.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.