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

349 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
backless16291063(None) 
barkless14318021barkless
tackless14419481tackless
backers153821882back_ers
backlash1945922backlash
backlist16910652backlist
backlists17117412backlists
backlogs1746632backlogs
backrest1639392backrest
backrests1744982backrests
backsets1638852backsets
barbless12318712barbless
barless94317002ba_rless
baseless1099562baseless
bathless13127382bathless
beakless14297382beakless
blacklegs1843912blacklegs
blackness1735662blackness
bractless1335542bractless
bucklers16349502bucklers
buckles153416092buckle_s
cacklers163710702cacklers
cackles153717202cackle_s
faceless13269172faceless
feckless17225782feckless
hacklers173710302hacklers
hackles162917062hackle_s
jacklegs2233952jacklegs
laceless10239852laceless
luckless14265892luckless
mackles154415752mackle_s
neckless14236432neckless
packness1636932packness
rankless12268232rankless
reckless14257972reckless
rockless14297292rockless
sockless14267792sockless
stackless1555932stackless
suckless14288822suckless
tacklers143010772tacklers
tackles133816522tackle_s
tactless10288462tactless
tankless12267822tankless
trackless15246722trackless
wickless1736082wickless
access1037673_ac_cess
ackees124914573_ack_ees
actress948533_actress
aculeus937513_aculeus
ageless8310343_ageless
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
ankles104818383_ankle_s
anklets114310413_anklets
armless9369943_armless
artless73712513_artless
ashless10318453_ashless
auklets11298573_auklets
aweless1038723_aweless
awless939263_a_wless
awnless1035923_awnless
babblers113510353babblers
babbles104416323babble_s
bacalaos1245863bacalaos
baches135426943bac_he_s
bacillus1245153bacillus
backbeat1847843backbeat
backbeats1945763backbeats
backbend1944783backbend
backbends2044093backbends
backcast1887673backcast
backcasts1985423backcasts
backcross1943923backcross
backed155725723back_e_d
backer144525523back_e_r
backfits19106953backfits
backflips2243333backflips
backflows2343873backflows
backhoes1938543backhoes
backings174012213backings
backland1748103backland
backlands1846823backlands
backlashes21125303backlashes
backlit15911903backl_it
backload1746833backload
backloads1846293backloads
backlog1635773backl_og
backmost1846633backmost
backouts1698643backouts
backrush1944103backrush
backs135729623back___s
backsaws1946803backsaws
backseat1648903backseat
backseats1746673backseats
backset15314193backse_t
backslaps1945253backslaps
backslash2044543backslash
backups1736173back_ups
backwash2244943backwash
baculums1443723baculums
badgeless1343203badgeless
badness1039573ba_dness
bafflers16356593bafflers
baffles153710683baffle_s
bailees93914383ba_ilees
bailers94221353ba_ilers
baileys12388933ba_ileys
bakers125323453ba_k_ers
bakes117035373ba_k_e_s
baldness1137043baldness
balers85626933ba__lers
bales76250083ba__le_s
balkers134915723balk_ers
balkiest144112453balkiest
balkiness1556903balkiness
ballers94421013ba_llers
ballets93719513ba_llets
bangles103617413bangle_s
bankers133919093bank_ers
bareness10912813bareness
barkeeps1634143barkeeps
barkers134318513bark_ers
barkiest144115153barkiest
barleys125011843ba_rleys
baroness101210063baroness
bascules1236683bascule_s
baseness10910943baseness
baskets135111833bask_ets
bassness1096743bassness
battlers104110973battlers
battles94517683battle_s
baubles113611863bauble_s
bawlers124412733ba_wlers
beamless12327003beamless
beardless1234913beardless
beatless103311593beatless
beckets15399823beck_ets
bedless1039703b_edless
beefless1335493beefless
beltless10297713beltless
benchless1644153benchless
bibless11439173b_ibless
bickers154316553bick_ers
blackens16388103black_ens
blackest16269303black_est
blacklead1863903blacklead
blackleads1993383blackleads
blackleg1734233blackle_g
blacklist1746123blacklist
blacklists1844183blacklists
bladeless1234303bladeless
blameless1334733blameless
blankness1544673blankness
bless75917813b___less
blotless10347143blotless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
booklets14247123booklets
boonless10328353boonless
bootless103410983bootless
bowless123310313b_owless
bracelets1345963bracelets
brackens16327923brack_ens
brackets163310433brack_ets
bractlets1344753bractlets
brainless1136403brainless
brakeless1544993brakeless
braless92910563b_raless
branchless1743303branchless
brandless1236123brandless
brickles162810283brickle_s
brimless1235273brimless
browless1346653browless
buckeens1634853buckeens
buckers153517453buck_ers
buckets153811693buck_ets
buckle144815193buckle__
buckled164411883buckle_d
buckler154112033buckle_r
buckoes153810393buckoe_s
budless1038873b_udless
bushless1335813bushless
cackle143416923cackle__
cackled164613293cackle_d
cackler153812573cackle_r
capless114312763ca_pless
careless102813633careless
carless95118493ca_rless
cashless1336773cashless
checkless2044233checkless
clickless1743983clickless
cockles153414643cockle_s
cookless14258633cookless
crackles164111273crackle_s
dackers143417043dack_ers
dankness13256693dankness
darkles124011933darkle_s
darkness13247343darkness
dateless9259963dateless
deckles143312803deckle_s
ductless11196313ductless
earless74316073ea_rless
fadeless12258323fadeless
fameless13259203fameless
fanciless1444603fanciless
fangless1237663fangless
fatless103212203fa_tless
ficklest17267903ficklest
fleckless1842893fleckless
flockless1843163flockless
forkless15267433forkless
frockless1843453frockless
gainless9117403gainless
gapless10349993ga_pless
garbless11388253garbless
gasless8319013ga_sless
gateless9279953gateless
graceless12226883graceless
grackles15309183grackle_s
hackees165014103hack_ees
hackers164619043hack_ers
hackies163418243hackie_s
hackle154916813hackle__
hackled173312483hackle_d
hackler163512353hackle_r
hackliest1836523hackliest
hackneys2033683hackneys
hairless1157413hairless
haltless11308443haltless
handless123512063handless
hapless123311333ha_pless
harmless1337403harmless
hatless103813443ha_tless
hecklers17357123hecklers
heckles163711383heckle_s
hookless151238363hookless
huckles163612623huckle_s
iceless9219963_iceless
inkless11348713_inkless
jacales16310323jacale_s
jackass2034963jack_ass
jackers204214453jack_ers
jacketless2341763jacketless
jackets205011373jack_ets
jackies202912623jackie_s
jackleg2135033jackle_g
jagless1537103ja_gless
jawless1745653ja_wless
keckles12318763keckle_s
knockless1442443knockless
laciness102112553laciness
lackers134120543lack_ers
lackeys16458263lack_eys
landless94011173landless
lankness12237043lankness
lawless1037033la_wless
leakless12246983leakless
mackle143716433mackle__
mackled164111913mackle_d
macles107023223mac_le_s
macules114015133macule_s
mailless10248583mailless
maneless102812343maneless
manless93012933ma_nless
massless10277113massless
mastless102610023mastless
matchless1644673matchless
mateless102711293mateless
matless93014043ma_tless
mickles153415003mickle_s
micklest16219123micklest
milkless1434773milkless
muckles153413253muckle_s
nameless10248373nameless
napless93110283na_pless
nathless11127023nathless
nickles133713823nickle_s
oarless73913373oa_rless
packers153818893pack_ers
packets155114773pack_ets
painless10108343painless
paneless102611763paneless
passless10247223passless
pastless102411203pastless
pathless13138043pathless
peakless14236683peakless
pickles153215443pickle_s
placeless1335613placeless
raciness102413453raciness
rackers134320453rack_ers
rackets134916873rack_ets
rackle123917293rackle__
rainless8129703rainless
ranchless1444453ranchless
rankles113114543rankle_s
rankness12267943rankness
rayless10239003ra_yless
riskless1235763riskless
ruckles133414603ruckle_s
sackers133820223sack_ers
sailless82410373sailless
saltless8259343saltless
sandless93212343sandless
sapless93313443sa_pless
sashless1136603sashless
scarless10189053scarless
shacklers18336033shacklers
shackles173010593shackle_s
sickles133417543sickle_s
sickness1437833sickness
slackness1535433slackness
spaceless1335733spaceless
spackles16319943spackle_s
stalkless1333723stalkless
sucklers14379963sucklers
suckles134516743suckle_s
tackers134319623tack_ers
tackets134914363tack_ets
tackiest143112433tackiest
tackiness1557693tackiness
tackle123815733tackle__
tackled143913183tackle_d
tackler134013323tackle_r
tailless8239083tailless
tameless10259903tameless
tapeless10218643tapeless
taxless1436903ta_xless
thankless1633203thankless
ticklers14339303ticklers
tickles133416853tickle_s
traceless11228643traceless
tuskless1234213tuskless
viceless1337983viceless
wackes154717713wack_e_s
wackest164710863wack_est
wackiest172610273wackiest
wackiness1836523wackiness
wageless1237173wageless
wakeless1536473wakeless
wardless12249303wardless
warless104015103wa_rless
wartless11279923wartless
wattless11268723wattless
waveless1437483waveless
wayless13308243wa_yless
workless15276803workless

Search took 10 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.1701051123.5
2DLD Change Limit1461623498.97016294.5
3Display Results3493490.1562237.2
 (SQL Overall)1786913499.29619222.4
 
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.