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

346 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
rainless812970(None) 
brainless1136401brainless
gainless9117401gainless
grainless1035891grainless
painless10108341painless
reinless8139431reinless
aidless83612072_aidless
aimless93610812_aimless
airless73712042_airless
awnless1035922_awnless
chinless1337492chinless
finless102810782_finless
frailness1236542frailness
hairless1157412hairless
kinless113310272_kinless
mailless10248582mailless
manless93012932ma_nless
raciness102413452racin_ess
railers74420662rai_lers
rainiest81214922rainiest
raininess949272raininess
rankless12268232rankless
rawness1038152rawn_ess
rayless10239002ra_yless
ribless93410342r_ibless
rimless9369362r_imless
rindless92510192r_indless
runless72810422r_unless
sailless82410372sailless
sinless73014212_sinless
skinless12216972skinless
spinless10238702spinless
stainless9176492stainless
tailless8239082tailless
taintless935732taintless
trailless935962trailless
vainness1136062vainness
veinless11136262veinless
winless103212282_winless
ageless8310343_ageless
aiglets84012913_aiglets
aisles64721143_aisle_s
aridness939223aridness
armless9369943_armless
artiness81615403artin_ess
artless73712513_artless
ashless10318453_ashless
aweless1038723_aweless
awless939263_a_wless
backless162910633backless
badness1039573badn_ess
bailees93914383bai_lees
bailers94221353bai_lers
baileys12388933bai_leys
barbless12318713barbless
barkless14318023barkless
barless94317003ba_rless
baseless1099563baseless
bathless13127383bathless
bibless11439173_bibless
boonless10328353boonless
bractless1335543bractless
braillers1135553braillers
brailles1039493braille_s
brainiest11209723brainiest
braininess1246123braininess
brainlessly1652373brainlessly
brakeless1544993brakeless
braless92910563bra__less
brandless1236123brandless
brimless1235273brimless
brineless1136243brineless
caginess11310303cagin_ess
cakiness1449553cakin_ess
capless114312763ca_pless
careless102813633careless
carless95118493ca_rless
cashless1336773cashless
craziness2037383crazin_ess
crownless1443423crownless
curtainless1351933curtainless
dateless9259963dateless
dauntless1033663dauntless
downless1236363downless
drabness1135803drabn_ess
drainers92811253drain_ers
dripless1135243dripless
earless74316073ea_rless
easiness8313043easin_ess
evilness1135043evilness
exitless1534883exitless
faceless13269173faceless
fadeless12258323fadeless
failles102914133faille_s
fainest10417703fain_est
fainters11349693fainters
faintest1139073faintest
faintness1235833faintness
fairness1136563fairness
faithless1543903faithless
fameless13259203fameless
fangless1237663fangless
farness102912203farn_ess
fatless103212203fa_tless
fatness103311293fatn_ess
fernless1136063fernless
frailest1139493frai_lest
frameless1435533frameless
fruitless1244163fruitless
gainers84214593gain_ers
gainliest1037133gainliest
gaminess112911063gamin_ess
gapless10349993ga_pless
garbless11388253garbless
gasless8319013ga_sless
gateless9279953gateless
gayness1136843gayn_ess
giantess933893giantess
graceless12226893graceless
gradeless11236703gradeless
grainers93012073grain_ers
grainiest10188993grainiest
graininess1145793graininess
grapiness1238253grapin_ess
grassless1034303grassless
grateless10277583grateless
graveless13226693graveless
grayness1235933grayn_ess
gunless8299633_gunless
hailers104017263hai_lers
haltless11308443haltless
handless123512063handless
hapless123311333ha_pless
harmless1337403harmless
harness102413933harn_ess
hatless103813443ha_tless
haziness20248513hazin_ess
heirless1146053heirless
hipless12399923_hipless
hitless103211193_hitless
hornless1137363hornless
hymnless1632803hymnless
iciness938863icin_ess
inkless11348713__inkless
inlets63915573__inlets
innless7288293_innless
jagless1537103ja_gless
jailers144114043jai_lers
jawless1745653ja_wless
jointless1634323jointless
kindless13289243_kindless
kingless13288693_kingless
laceless10239853laceless
laciness102112553lacin_ess
landless94011173landless
lawless1037033la_wless
laxness1436043laxn_ess
laziness17239983lazin_ess
lidless8309273_lidless
lineless82711943_lineless
lintless82710013_lintless
lipless9259553_lipless
madness10310073madn_ess
mailers94420333mai_lers
mailes84329113mai_le_s
maneless102812343maneless
massless10277113massless
mastless102610023mastless
mateless102711293mateless
matiness102114753matin_ess
matless93014043ma_tless
maziness19239543mazin_ess
mindless11319443_mindless
moonless10278043moonless
nailers73215893nai_lers
nameless10248373nameless
napless93110283na_pless
nathless11127023nathless
nounless837253nounless
oarless73913373oa_rless
painlessly1543003painlessly
painters103013023painters
paisleys1333343paisleys
paneless102611763paneless
passless10247223passless
pastless102411203pastless
pathless13138043pathless
patness92912283patn_ess
plainness1155183plainness
planless1036813planless
pointless1135703pointless
princess12266803princess
printless1137513printless
rabblers123810853rabblers
rabbles113517973rabble_s
rabidness12145263rabidness
raddles93615703raddle_s
radicles11249703radicle_s
rafflers14317363rafflers
raffles133611843raffle_s
raggles93813283raggle_s
raiders84615143rai_ders
railbus934413rai_lbus
railed74727543rai_le_d
railer64524933rai_le_r
raillery1134953raillery
rails55937403rai_l__s
rainbows1343243rainbows
rained75024603rain_e_d
rainier71614263rainie_r
rainouts846913rainouts
rains55140233rain___s
rainwash1443063rainwash
rainwear1143093rainwear
raisers73617393rai_sers
raises64826543rai_se_s
rales54947493ra__le_s
ramblers124010373ramblers
rambles113118313ramble_s
rances84625443ra_nce_s
ranchless1444453ranchless
randiness102511443randin_ess
ranees64623963ra_n_ees
rangers83621043ra_ngers
ranges73826923ra_nge_s
ranginess101610213rangin_ess
rankers113217463ra_nkers
rankest112713813ra_nkest
rankles113114543rankle_s
rankness12267943rankness
ranters73323643ra_nters
rapidness12155473rapidness
rapines95120863rapin_e_s
raptness1046733raptness
rareness81112853rareness
rashness1138093rashness
raspiness1137303raspin_ess
rassles73513923rassle_s
ratines75328583ratin_e_s
rattlers83510293rattlers
rattles73217303rattle_s
ravelers113310863ravelers
ravines104220233ravin_e_s
readiness102611853readin_ess
realness8410443realn_ess
reasonless1043523reasonless
reckless14257973reckless
redness82012443redn_ess
reinters82614773reinters
reinvest1138203reinvest
reinvests1244223reinvests
restless82713163restless
riblets93412553r_iblets
ridleys11145783r_idleys
riflers103512193r_iflers
rifles94217703r_ifle_s
riftless1136943riftless
riles55343643r_i_le_s
rilles64725503r_ille_s
rillets74216153r_illets
riminess10510093rimin_ess
ringers83922953r_ingers
ringlets92910233r_inglets
rinsers73815743r_insers
rinses64720383r_inse_s
riskless1235763riskless
roadless937703roadless
rockless14297293rockless
rodless8310073r_odless
roofless11316733roofless
rootless83910443rootless
ropiness102311073ropin_ess
rosiness82613173rosin_ess
ruiners74213023ruin_ers
ruleless836633ruleless
rumpless12256543rumpless
rungless956733rungless
runlets73310773r_unlets
rustless83510243rustless
ruthless1135413ruthless
sadness8310613sadn_ess
sailers73822323sai_lers
saltless8259343saltless
sandless93212343sandless
sapless93313443sa_pless
sashless1136603sashless
shipless13277693shipless
shitless11249243shitless
skilless12246763skilless
slipless10246993slipless
slitless8268143slitless
soilless8279033soilless
sonless72612613_sonless
spanless10247363spanless
spineless1136133spineless
stairless9185623stairless
stingless1046463stingless
sunless73013693_sunless
tackless14419483tackless
tactless10288463tactless
tailers73720183tai_lers
tailles72516473taille_s
tallness837103tallness
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
taxless1436913ta_xless
thinness11277163thinness
tieless72512563_tieless
tintless8239863_tintless
tipless92610063_tipless
townless1135653townless
traceless11228643traceless
trackless15246723trackless
trailers82912923trai_lers
trainees82712063train_ees
trainers83114643train_ers
traitress944403traitress
tramless1037503tra_mless
twigless1293663twigless
unless62413073__unless
vainest10315763vain_est
veinlets11144833veinlets
waeness102512783waen_ess
wageless1237173wageless
wailers103916803wai_lers
waistless1235093waistless
waitress1135223waitress
wakeless1536473wakeless
wanness102610683wa_nness
wardless12249303wardless
wariness11313213warin_ess
warless104015103wa_rless
wartless11279923wartless
wattless11268723wattless
waveless1437483waveless
waviness1437723wavin_ess
waxiness1836723waxin_ess
wayless13308243wa_yless
wigless11359673_wigless
windless123310863_windless
wineless112711173_wineless
wingless122910023_wingless
witless103310983_witless
zaniness1738663zaniness
zipless18276303_zipless

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.406440125.6
2DLD Change Limit1461623467.32619951.1
3Display Results3463460.1402471.4
 (SQL Overall)1786913467.87222699.6
 
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.