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

365 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
useless718842(None) 
fuseless11237231fuseless
ageless8310342ageless
ashless10318452ashless
aweless1038722aweless
baseless1099562baseless
bushless1335812bushless
causeless1135192causeless
cureless10319702cureless
dustless9328342dustless
eyeless1058052eyeless
feeless103511102feeless
fumeless13236602fumeless
gustless9287682gustless
houseless1237462houseless
hueless1058822hueless
iceless9219962iceless
ireless72312242ireless
isleless834852isleless
noseless839512noseless
ruleless836632ruleless
rustless83510232rustless
sexless1467242_sexless
sumless92611122sumless
sunless73013692sunless
tieless72512562tieless
toeless72612392toeless
tubeless1037022tubeless
tuneless837912tuneless
tuskless1234212tuskless
unless62413072u_nless
uselessly1243452uselessly
abeles84719393abele_s
aidless83612073aidless
aimless93610813aimless
airless73712043airless
aneles64626293anele_s
armless9369943armless
artless73712513artless
asepses946363asepses
ashlers10319583ashlers
assess65710463as_sess
assetless943573assetless
awless939263_awless
awnless1035923awnless
barless94317003barless
baseness10910943baseness
bedless1039703bedless
beefless1335493beefless
bibless11439173bibless
bless75917813__bless
boneless10310213boneless
bowless123310313bowless
braless92910563braless
brushless1444003brushless
budless1038873budless
bushelers1474113bushelers
business102110683business
bustlers104210613bustlers
bustles93816323bustle_s
busyness13264803busyness
capless114312763capless
careless102813633careless
carless95118493carless
cashless1336773cashless
ceaseless1135733ceaseless
celebs1037883_celebs
clueless1035883clueless
codeless112010113codeless
coreless103013833coreless
costless10310003costless
coxless1637743coxless
crewless1335403crewless
crustless1155393crustless
cuffless1634283cuffless
cupelers1266733cupelers
cuteness1039673cuteness
dateless9259963dateless
deedless10318253deedless
deles65139253_dele_s
dewless1137473dewless
ductless11196313ductless
duelers83412053duelers
dueness82310123dueness
earless74316063earless
edgeless1034883edgeless
eggless935663eggless
egoless836983egoless
endless839833endless
eusteles838043eustele_s
eyelets1057523eyelets
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
fatless103212203fatless
feelers103814743feelers
feetless1137383feetless
finless102810783finless
fireless112810593fireless
fishless1436413fishless
flyless1335003flyless
fogless1138193fogless
fretless1138063fretless
fuelers103912393fuelers
furless103210143furless
fusees95416403fuse_e_s
fusels94412453fusel__s
gapless10349993gapless
gasless8319013gasless
gateless9279953gateless
gelees74116263_gelees
godless938403godless
guideless1143843guideless
guileless1044253guileless
gumless10228273gumless
gunless8299633gunless
gutless82610713gutless
hapless123311333hapless
hatless103813443hatless
heedless12278813heedless
heelers103815623heelers
heelless11257653heelless
hideless12278713hideless
hipless12399923hipless
hitless103211193hitless
hiveless14227933hiveless
holeless1189363holeless
homeless131110133homeless
hopeless13118303hopeless
horseless1237213horseless
hugeness1237373hugeness
humpless15226333humpless
hurtless11307783hurtless
hustlers11349203hustlers
hustles103414173hustle_s
idealess935653idealess
inkless11348713inkless
innless7288293innless
isles54220563is_le_s
islets64513083is_lets
issueless942393issueless
istles62814983istle_s
jagless1537103jagless
jawless1745653jawless
jobless16237563jobless
joyless17226513joyless
juiceless1843253juiceless
juryless1832983juryless
justles143311433justle_s
justness1535323justness
keelless12236193keelless
keleps12478813_keleps
keyless1436163keyless
kinless113310273kinless
laceless10239853laceless
lawless1037033lawless
legless838013legless
less45635103___less
lidless8309273lidless
lifeless11228143lifeless
limeless10249663limeless
lineless82711943lineless
lipless9259553lipless
listless8269263listless
lossless835473lossless
loveless1168573loveless
luckless14265893luckless
lushness1136233lushness
lusterless1043693lusterless
maneless102812343maneless
manless93012933manless
massless10277113massless
mastless102610023mastless
mateless102711293mateless
matless93014043matless
melees83618083_melees
menseless1145203menseless
moveless1367753moveless
muscles11310563muscle_s
musicless1343593musicless
muteness1039013muteness
nameless10248373nameless
napless93110283napless
needless9308333needless
netless739863netless
noiseless945553noiseless
noteless839403noteless
nudeness936733nudeness
oarless73913373oarless
omelets938333omelets
oneness7512143oneness
orbless937493orbless
ostlers72911203ostlers
ousels64815273ousel__s
outbless1037963outbless
paneless102611763paneless
passless10247223passless
pastless102411203pastless
peelers93615593peelers
peeress939503peeress
peerless1037503peerless
pegless1038053pegless
peles75738083_pele_s
pileless1088623pileless
pipeless12107663pipeless
poetess938933poetess
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
prebless1236823prebless
precess11310863precess
pulpless12224953pulpless
pumpless14236373pumpless
pureness101110183pureness
pusleys12286233pus_leys
pussleys13273173pussleys
queleas1636723queleas
rayless10239003rayless
recess8314263_recess
reelers73520273reelers
relets64025673_relets
restless82713163restless
ribless93410343ribless
rimless9369363rimless
riskless1235763riskless
rodless8310073rodless
rudeness938083rudeness
rumpless12256543rumpless
rungless956733rungless
runless72810423runless
rustlers8339853rustlers
rustles73416413rustle_s
ruthless1135413ruthless
saleps85014903_saleps
sales56055593_sale_s
sapless93313443sapless
sashless1136603sashless
sealers74323553_sealers
seamless10238723_seamless
seatless83213003_seatless
seders74420283_seders
seedless9319513seedless
seeds64330063_se_eds
seeks94724643_se_eks
seels55632823_se_els
seems75525023_se_ems
seeps74828753_se_eps
seeress7311573seeress
seers55136383_se_ers
sees45361053_se_e_s
seises64026713_seises
selahs9313213_selahs
select82621173_select
selects91912143_selects
selfless1135013_selfless
selfness1135153_selfness
selfs85220243_sel_fs
sellers73721303_sellers
selles64426983_selles
sells55134433_sel_ls
sels46345983_sel__s
selvas93812913_selvas
selves94119613_selves
semens84616963_semens
semes75731583_seme_s
senseless945973senseless
senses63923943_senses
sepses84515883_sepses
seres55448893_sere_s
serest64831613_serest
sevens93813663_sevens
severs94121123_severs
sewers94719713_sewers
sexes126126223_sexe_s
shleps114710333_shleps
shoeless1137803shoeless
sinless73014213sinless
sleds64418853_s_leds
sleeks104512463_sleeks
sleeps83913323_sleeps
sleets64318873_sleets
slews86220353_s_lews
soleless8910033soleless
soles55547923_sole_s
soleus64615613_soleus
sonless72612613sonless
steles63725663stele_s
stemless1036653stemless
stress66616673_stress
sublets92616703sublets
success1146403success
suckless14288823suckless
sudsless944353sudsless
suedes73918113suede_s
sureness8912903sureness
sutlers73116973sutlers
tameless10259903tameless
tapeless10218643tapeless
tasteless935673tasteless
taxless1436903taxless
teles54536003_tele_s
teleses7313123_teleses
telesis7310793_telesis
thewless1433923thewless
tideless9269083tideless
timeless10239543timeless
tipless92610063tipless
tireless82510263tireless
toneless8610393toneless
topless92511123topless
toyless10268713toyless
treeless839283treeless
truceless11235393truceless
trustless955933trustless
tsetses785453tsetses
tugless837383tugless
turfless1135533turfless
tussles737833tussle_s
ukelele1142993ukelele
ukeleles1252663ukeleles
umbles103817483umble_s
unblest9411813unblest
uncles8317163uncle_s
undress838893undress
uneases73316263uneases
unsells73210773unsel_ls
unsexes14248923unsexe_s
unstress837373unstress
ureases74416723ureases
ureters7311823ureters
usages759603usage_s
usefulness1345703usefulness
users55817573us__ers
uses44931113us__e_s
ushers94415533us_hers
usneas638333us_neas
usques15126803usque_s
usualness993563usualness
usurers766363usurers
vestless11258843vestless
viceless1337983viceless
viewless1434033viewless
voteless1137493voteless
vowless13246603vowless
waeness102512783waeness
wageless1237173wageless
wakeless1536473wakeless
warless104015103warless
waveless1437483waveless
wayless13308243wayless
webless1237003webless
weedless12287963weedless
wifeless14277483wifeless
wigless11359673wigless
wineless112711173wineless
winless103212283winless
wireless11249633wireless
wiseness112010753wiseness
wishless1435993wishless
witless103310983witless
woeness1020211543woeness
yokeless1535303yokeless
zestless17247433zestless
zipless18276303zipless
zoneless1737823zoneless

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273658.12616493.6
3Display Results3653650.1232967.5
 (SQL Overall)1786913658.40521260.1
 
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.