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

369 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
orbless93749(None) 
armless9369942armless
artless73712512artless
barbless12318712barbless
bibless11439172bibless
bless75917812__bless
braless92910562braless
cordless11299962cordless
coreless103013832coreless
fordless12289002fordless
forkless15267432forkless
formless13248082formless
garbless11388252garbless
gormless11235442gormless
herbless1336662herbless
hornless1137362hornless
ireless72312242ireless
jobless16237562jobless
lordless9277482lordless
normless10235922normless
oarless73913372oarless
obsess845942o_bsess
orbiest9312412orbiest
orles55326212or_le_s
outbless1037962outbless
portless10310642portless
prebless1236822prebless
ribless93410342ribless
robles85321692roble_s
rodless8310072rodless
tombless1236772tombless
verbless1336032verbless
webless1237002webless
wordless12258842wordless
workless15276802workless
abbess10509773_abbess
ables75935543_able_s
ablest84721833_ablest
ageless8310343ageless
aidless83612073aidless
aimless93610813aimless
airless73712043airless
amblers115213563amblers
ambles105121863amble_s
arables91814973arable_s
arbalest1039523arbalest
arbalests1144123arbalests
arbelest1049503arbelest
arbelests1143653arbelests
argles75218483argle_s
arles56735743ar_le_s
armlets94610063armlets
ashless10318453ashless
aweless1038723aweless
awless939263_awless
awnless1035923awnless
barkless14318023barkless
barless94317003barless
bedless1039703bedless
bibles104617643bible_s
blebs96416153__blebs
blest76431723__blest
blets75324943__blets
bliss75616913__bliss
bobbles104514913bobble_s
bodiless1135913bodiless
boltless10338283boltless
bomblets1436023bomblets
bondless1148813bondless
boneless10310213boneless
boonless10328353boonless
bootless103410983bootless
bowless123310313bowless
brimless1235273brimless
browless1346653browless
budless1038873budless
burblers12399263burblers
burbles114916803burble_s
cablers114416713cablers
cables104527553cable_s
cablets114216343cablets
capless114312763capless
careless102813633careless
carless95118493carless
coalless1038193coalless
coatless1039693coatless
cobblers14359593cobblers
cobbles133814823cobble_s
cobles104622883coble_s
codeless112010113codeless
cookless14258633cookless
corbels113813593corb_els
corbies113520123corbie_s
corslets1038273corslets
corulers1039773corulers
costless10310003costless
coxless1637743coxless
cress75022833cr__ess
crewless1335403crewless
cropless1237793cropless
cureless10319703cureless
debtless1135653debtless
dewless1137473dewless
doorless936713doorless
doublers11288503doublers
doubles103113353double_s
doublets11257363doublets
doubtless1243313doubtless
downless1236363downless
drabness1135803drabness
dress65319833dr__ess
driblets11266093driblets
dripless1135243dripless
dryness11114783dryness
earless74316073earless
eggless935663eggless
egoless836983egoless
emblems1335043emblems
endless839833endless
eyeless1058053eyeless
fablers124812613fablers
fables114921673fable_s
fatless103212203fatless
feeless103511103feeless
fernless1136063fernless
finless102810783finless
fireless112810593fireless
flyless1335003flyless
foamless13195843foamless
fogless1138193fogless
foibles1238853foible_s
foodless12338383foodless
footless113710803footless
forceless1435723forceless
forelegs1236613forelegs
fortress1136753fortress
fretless1138063fretless
furless103210143furless
gables94222333gable_s
gapless10349993gapless
garblers113810283garblers
garbles104016923garble_s
gasless8319013gasless
giblets103210423giblets
goalless935723goalless
gobblers13308343gobblers
gobbles123512583gobble_s
goblets103210183goblets
godless938403godless
goriness9310753goriness
grilses8319153grilses
gumless10228273gumless
gunless8299633gunless
gutless82610713gutless
hapless123311333hapless
harmless1337403harmless
hatless103813443hatless
hipless12399923hipless
hitless103211193hitless
hobblers15308513hobblers
hobbles143313783hobble_s
holeless1189363holeless
homeless131110133homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279253hoopless
hopeless13118303hopeless
horseless1237213horseless
hueless1058823hueless
hurtless11307783hurtless
iceless9219963iceless
inkless11348713inkless
innless7288293innless
jagless1537103jagless
jawless1745653jawless
joyless17226513joyless
juryless1832983juryless
keyless1436163keyless
kinless113310273kinless
lawless1037033lawless
legless838013legless
less45635103___less
lidless8309273lidless
limbless12246313limbless
lipless9259553lipless
loamless10235213loamless
loftless1135903loftless
lornness836493lornness
lossless835473lossless
loveless1168573loveless
manless93012933manless
marblers12319233marblers
marbles114516653marble_s
matless93014043matless
moonless10278043moonless
morales93619403morale_s
moreness10911573moreness
moveless1367753moveless
napless93110283napless
netless739863netless
nobblers12318563nobblers
nobbles114014523nobble_s
nobles83319723noble_s
noblesse1044533noblesse
noblest93613563noblest
nombles113212343nomble_s
noseless839513noseless
noteless839403noteless
nounless837253nounless
obelus8348403o_belus
obes66036833o_b_e_s
obese75212423o_b_ese
obeys107010643o_b_eys
objets15125323o_bjets
oblast8613663o_blast
oblasts947293o_blasts
oboes75717713o_boe_s
oboles83815833obole_s
obtest81213013o_btest
obtests9136233o_btests
oddness935313oddness
odorless934173odorless
odyles10348563odyle_s
oglers74313183o_glers
ogles65223183o_gle_s
ogress7529503o_gress
oilers64721193o_ilers
oldness836403oldness
oleos55419683o__leos
oles46453473o__le_s
ombers104214403omb_ers
ombres103911143ombre_s
omelets938333omelets
oneness7512143oneness
oodles73517183oodle_s
oppress1135993oppress
oracles93212423oracle_s
oralism9513763oralism
oralisms10610973oralisms
oralist7619633oralist
oralists8611803oralists
orals55826483oral__s
orates64328613orate_s
oratress834553oratress
orbed85516193orb_e_d
orbier839993orbie_r
orbiters1036593orbiters
orbits84211443orb_its
orbs66626253orb___s
orderless1044313orderless
orders74315993or_ders
ores46056683or__e_s
orgies72316093orgie_s
oriels64914623or_iels
orioles7412993oriole_s
orle45630463or_le__
orlons6411013or_lons
orlops847303or_lops
ormers84316143or_mers
orrises71312233orrises
oryxes1674523oryxe_s
ostlers72911203ostlers
outlets73616363outlets
ovalness1134673ovalness
ovules938223ovule_s
owlets93110393o_wlets
pegless1038053pegless
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
portress1038323portress
precess11310863precess
press75425953pr__ess
problems1434343problems
process11310403process
profess1237713profess
prolegs10379993prolegs
proles84627203prole_s
prowess1237903prowess
rales54947493_rale_s
rayless10239003rayless
recess8314263_recess
relets64025673_relets
riblets93412553riblets
riles55343643_rile_s
rimless9369363rimless
roadless937703roadless
robbers112814163robbers
robes75133303rob_e_s
roble75223023roble__
rockless14297293rockless
roles56747983_role_s
rollers73117473rollers
roofless11316733roofless
rootless83910443rootless
roubles93413513rouble_s
rubles83921703ruble_s
rulers64317093_rulers
rules55234253_rule_s
runless72810423runless
sables85026693sable_s
sapless93313443sapless
scoreless1155603scoreless
sexless1467243sexless
shoreless1236633shoreless
sinless73014213sinless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
songless9218823songless
sonless72612613sonless
sorbets93012503sorb_ets
sorboses1038523sorboses
soreness8914793soreness
soulless8218763soulless
soupless10268463soupless
sublets92616703sublets
sumless92611123sumless
sunless73013693sunless
tables84524883table_s
tablets94714373tablets
taxless1436903taxless
termless1036233termless
thornless1243633thornless
tieless72512563tieless
tipless92610063tipless
tireless82510263tireless
toadless936313toadless
toeless72612393toeless
toneless8610393toneless
toolless836343toolless
topless92511123topless
townless1135653townless
toyless10268713toyless
tramless1037503tramless
trebles9311443treble_s
treeless839283treeless
tress55423163tr__ess
tubeless1037023tubeless
tugless837383tugless
turfless1135533turfless
umbles103817493umble_s
unblest9411813unblest
unless62413073_unless
useless7188423useless
voteless1137493voteless
vowless13246603vowless
warblers13319103warblers
warbles123215563warble_s
wardless12249303wardless
warless104015103warless
wartless11279923wartless
wayless13308243wayless
wigless11359673wigless
winless103212283winless
wireless11249633wireless
witless103310983witless
wobblers15327883wobblers
wobbles143412433wobble_s
woodless12278453woodless
wornness1136363wornness
worthless1544923worthless
wryness13113983wryness
yokeless1535303yokeless
zipless18276303zipless
zoneless1737823zoneless

Search took 8 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.1561145455.1
2DLD Change Limit1340273696.72019944.5
3Display Results3693690.1262928.6
 (SQL Overall)1786913697.00225520.0
 
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.