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

411 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
jawless174565(None) 
awless939261_awless
jagless1537101jagless
lawless1037031lawless
aweless1038722_aweless
awnless1035922_awnless
barless94317002barless
bawlers124412732bawlers
bowless123310312bowless
capless114312762capless
carless95118492carless
clawless1334122clawless
dewless1137472dewless
earless74316072earless
fatless103212202fatless
flawless1434502flawless
gapless10349992gapless
gasless8319012gasless
hapless123311332hapless
hatless103813442hatless
jailers144114042jailers
jobless16237562jobless
joyless17226512joyless
manless93012932manless
matless93014042matless
napless93110282napless
oarless73913372oarless
rawness1038152rawness
rayless10239002rayless
sapless93313442sapless
taxless1436912taxless
thawless1434082thawless
vowless13246602vowless
warless104015102warless
wayless13308242wayless
abbess10509773_abbess
ables75935543_able_s
ablest84721833_ablest
access1037683_access
ageless8310343ageless
aglets73915683_aglets
aidless83612073aidless
aimless93610813aimless
airless73712043airless
alecs76620733_a_lecs
alefs87319663_a_lefs
ales47067103_a_le_s
allees64521483_allees
alleys95113303_alleys
arles56735743_arle_s
armless9369943armless
artless73712513artless
ashless10318453ashless
assess65710463_assess
awes76037553_aw_e_s
awls75926093_awl__s
axles125219473_axle_s
backless162910633backless
badness1039573badness
bailees93914383bailees
bailers94221353bailers
baileys12388933baileys
balers85626933ba_lers
bales76250083ba_le_s
ballers94421013ballers
ballets93719513ballets
barbless12318713barbless
barkless14318023barkless
barleys125011843barleys
baseless1099563baseless
bathless13127383bathless
bawbees14337243bawbees
bawled124415693bawle_d
bawler114315053bawle_r
bawls105719323bawl__s
beakless14297383beakless
beamless12327003beamless
beatless103311593beatless
bedless1039703bedless
bibless11439173bibless
bless75917813__bless
bowlegs13366823bowlegs
bowlers123715783bowlers
braless92910563braless
brawlers13408643brawlers
browless1346653browless
budless1038873budless
cablers114416713cablers
cables104527553cable_s
cablets114216343cablets
calesa8412473ca_lesa
calesas9411833ca_lesas
callees94117783callees
callers94221963callers
callets93821703callets
camlets114314623camlets
caplets114914523caplets
careless102813633careless
caress85720263ca_ress
carles85435083carle_s
cashless1336773cashless
caules85927253caule_s
chadless1436403chadless
coalless1038193coalless
coatless1039693coatless
coxless1637743coxless
crawlers13309013crawlers
crewless1335413crewless
dales66439743da_le_s
dalles74222063dalle_s
dateless9259963dateless
dawdlers13375673dawdlers
dawdles12379163dawdle_s
downless1236363downless
drawlers12307313drawlers
eagles73819163eagle_s
eaglets84111663eaglets
eggless935663eggless
egoless836983egoless
endless839833endless
eyeless1058053eyeless
fablers124812613fablers
fables114921673fable_s
faceless13269173faceless
fadeless12258323fadeless
fallers103917993fallers
fameless13259203fameless
fangless1237663fangless
farles96025783farle_s
farness102912203farness
fatness103311293fatness
fawners13388493fawners
fearless1137873fearless
feeless103511103feeless
fewness1335003fewness
finless102810783finless
flagless1235403flagless
flapless1335343flapless
flyless1335003flyless
foamless13195843foamless
fogless1138193fogless
fowlers133411203fowlers
furless103210143furless
gables94222333gable_s
gainless9117403gainless
galeas74618513ga_leas
gales65442483ga_le_s
galleass935053galleass
gallets83517403gallets
galleys11369713galleys
gaolers83511563gaolers
garbless11388253garbless
gateless9279953gateless
gawkers15347453gawkers
gawpers13448313gawpers
gayness1136843gayness
gearless937373gearless
goalless935723goalless
godless938403godless
gumless10228273gumless
gunless8299633gunless
gutless82610713gutless
hailers104017263hailers
hairless1157413hairless
halers94926913ha_lers
hales85449843ha_le_s
halest94823273ha_lest
hallels103310133hallels
haltless11308443haltless
hamlets123211403hamlets
handless123512063handless
haoles94919803haole_s
harmless1337403harmless
harness102413933harness
haslets102510863haslets
haulers104012443haulers
hawkers174210333hawkers
hawkeys20414703hawkeys
hawsers13409483hawsers
hawses125113993hawse_s
headless12289863headless
heatless113011463heatless
hipless12399923hipless
hitless103211193hitless
howlers133312353howlers
howlets13329223howlets
hueless1058823hueless
iceless9219963iceless
inkless11348713inkless
innless7288293innless
ireless72312243ireless
jabbers183610583jabbers
jacales16310323jacale_s
jackass2034963jackass
jackers204214453jackers
jackets205011373jackets
jacklegs2233963jacklegs
jades135222113ja_de_s
jaegers15307103jaegers
jagers144415723ja_gers
jaggers164012893jaggers
jailed144917423jaile_d
jailer134316683jaile_r
jailors14328753jailors
jails125422943jail__s
jakes165023643ja_ke_s
jalaps15299183ja_laps
jalops15329593ja_lops
jambes175914053jambe_s
jammers183710703jammers
janes124928123ja_ne_s
janglers16319373janglers
jangles154015683jangle_s
japers154616173ja_pers
japes146322823ja_pe_s
jarls126120963jarl__s
jarveys20123413jarveys
jaspers164310463jaspers
jawans1657843jaw_ans
jawed165517373jaw_e_d
jawlike21116003jawlike
jawline17137063jawline
jawlines18126363jawlines
jaws145027293jaw___s
jaygees1854513jaygees
jayvees2052923jayvees
jazzers22324763jazzers
jazzes21347883jazze_s
jess116022033j___ess
jewelers1834713jewelers
jewels16508613jew_els
joles125230833j_ole_s
joules134116823joule_s
jowled174210803jowle_d
jowliest18247623jowliest
jowliness1934853jowliness
jowls156214523jowl__s
juleps1535623j_uleps
juryless1832983juryless
kales95730983ka_le_s
kayles134712003kayle_s
keyless1436163keyless
kinless113310273kinless
laceless10239853laceless
ladlers84613573ladlers
ladles74619543ladle_s
landless94011173landless
largess8408913largess
lawlessly1542813lawlessly
lawyers13377153lawyers
laxness1436043laxness
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013legless
less45635103___less
lidless8309273lidless
lipless9259553lipless
loamless10235213loamless
lowness1037813lowness
macles107023223macle_s
madness10310073madness
maglevs1334693maglevs
mailers94420333mailers
mailes84329113maile_s
mailless10248583mailless
males75049793ma_le_s
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
maneless102812343maneless
maples104819423maple_s
massless10277113massless
mastless102610023mastless
mateless102711293mateless
maulers94213303maulers
mealless10288363mealless
meatless103410863meatless
mewlers12288983mewlers
nailers73215893nailers
naleds7469133na_leds
nameless10248373nameless
nathless11127023nathless
netless739863netless
newness1035703newness
newsless1134533newsless
nowness1037033nowness
orbless937493orbless
owlets93110393_owlets
padles95221123padle_s
painless10108343painless
pales75753803pa_le_s
palest83926223pa_lest
palets85122313pa_lets
pallets93919303pallets
paneless102611763paneless
parles86334403parle_s
parleys125212373parleys
passless10247223passless
pastless102411203pastless
pathless13138043pathless
patness92912283patness
pawers114818783paw_ers
pawls105617663pawl__s
pawnees12298173pawnees
pawners124311073pawners
peakless14236683peakless
pegless1038053pegless
planless1036813planless
playless1334863playless
railers74420663railers
rainless8129703rainless
rales54947493ra_le_s
rankless12268233rankless
rawest93615063raw_est
ribless93410343ribless
rimless9369363rimless
roadless937703roadless
rodless8310073rodless
runless72810423runless
sables85026693sable_s
sadness8310613sadness
sailers73822323sailers
sailless82410373sailless
saleps85014903sa_leps
sales56055593sa_le_s
sallets73719653sallets
saltless8259343saltless
samlets93813553samlets
sandless93212343sandless
sashless1136603sashless
sawers94620163saw_ers
sawlogs1135393sawlogs
sawneys13274643sawneys
sawyers13317533sawyers
scarless10189053scarless
seamless10238723seamless
seatless83213003seatless
sexless1467243sexless
sinless73014213sinless
snapless10287463snapless
snowless1145633snowless
soapless10278073soapless
sonless72612613sonless
spanless10247363spanless
starless81610843starless
sumless92611123sumless
sunless73013693sunless
swales93920763swale_s
tables84524893table_s
tablets94714383tablets
tackless14419483tackless
tactless10288463tactless
tailers73720183tailers
tailless8239083tailless
talers64628143ta_lers
tales55451373ta_le_s
tallest7317093tallest
tallness837103tallness
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
tawers94118603taw_ers
tawneys13324773tawneys
tawses94913193tawse_s
tearless848713tearless
thewless1433923thewless
thowless1434613thowless
tieless72512563tieless
tipless92610063tipless
toadless936313toadless
toeless72612393toeless
topless92511123topless
townless1135653townless
toyless10268713toyless
tramless1037503tramless
trawlers113310203trawlers
trawleys14284383trawleys
tugless837383tugless
unless62413073_unless
useless7188423useless
vales85434263va_le_s
valets93715623va_lets
valleys13407483valleys
valses94514613va_lses
varlets10411573varlets
viewless1434033viewless
waeness102512783waeness
wageless1237173wageless
wailers103916803wailers
wakeless1536473wakeless
walers94824463wa_lers
wales86142833wa_le_s
wallets103914833wallets
wanness102610683wanness
wardless12249303wardless
wartless11279923wartless
wattless11268723wattless
waveless1437483waveless
wawled133811703wawle_d
wawls115416473wawl__s
webless1237003webless
wigless11359673wigless
winless103212283winless
witless103310983witless
yawled13459983yawle_d
yawls114613603yawl__s
yawners13367183yawners
yawpers15346853yawpers
yowlers13328923yowlers
zipless18276303zipless

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 Filter1786911340270.440406115.9
2DLD Change Limit1340274115.92022639.7
3Display Results4114110.1402935.7
 (SQL Overall)1786914116.50027490.9
 
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.