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

311 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
treeless83928(None) 
crewless1335402crewless
feeless103511102_feeless
freeness11710442freeness
fretless1138062fretless
greedless1144892greedless
ireless72312242ir_eless
prebless1236822prebless
reelers73520272_reelers
tameless10259902tameless
tapeless10218642tapeless
termless1036232termless
thewless1433922thewless
tideless9269082tideless
tieless72512562t_ieless
timeless10239542timeless
tireless82510262tireless
toeless72612392t_oeless
toneless8610392toneless
traceless11228642traceless
tramless1037502tramless
treadless1036002treadless
trebles9311442treble_s
truceless11235392truceless
trueness838682trueness
tubeless1037022tubeless
tuneless837912tuneless
tweeness11246402tweeness
ageless8310343_ageless
arbelest1049503arbelest
arbelests1143653arbelests
areoles71016953areole_s
armless9369943ar_mless
artless73712513ar_tless
aweless1038723_aweless
baseless1099563baseless
bedless1039703_bedless
beefless1335493beefless
boneless10310213boneless
brakeless1544993brakeless
braless92910563br_aless
breadless1235943breadless
breeders11368893breeders
breezeless2141693breezeless
breezes18318693breeze_s
briefless1443613briefless
brimless1235273brimless
brineless1136243brineless
browless1346653browless
careless102813633careless
cheekless1873883cheekless
cheerless1495293cheerless
clueless1035883clueless
codeless112010113codeless
coreless103013833coreless
creaseless1243643creaseless
creeled104012013creele_d
creels84416943creel__s
creepers12318623creepers
creeses93914623creese_s
creoles9913323creole_s
crestless1146783crestless
crimeless1335063crimeless
cropless1237793cropless
cruelest1059183cruelest
cruelness1145053cruelness
cureless10319703cureless
dateless9259963dateless
deedless10318253deedless
dewless1137473_dewless
dreamless1243513dreamless
dripless1135243dripless
edgeless1034883edgeless
eyeless1058053_eyeless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
feelers103814743_feelers
feetless1137383feetless
fernless1136063fernless
fireless112810593fireless
forceless1435723forceless
frameless1435533frameless
freebees1345353freebees
freezers20307173freezers
freezes193310353freeze_s
fumeless13236603fumeless
fuseless11237233fuseless
gateless9279953gateless
glebeless1242953glebeless
graceless12226883graceless
gradeless11236703gradeless
grateless10277573grateless
graveless13226693graveless
greaseless1143483greaseless
greenest9312623greenest
greenlets1044703greenlets
greenness1046793greenness
greeters92610113greeters
greyness1235243greyness
groveless13235363groveless
gruelers936173gruelers
heedless12278813heedless
heelers103815623_heelers
heelless11257653heelless
herbless1336663herbless
hideless12278713hideless
hiveless14227933hiveless
holeless1189363holeless
homeless131110133homeless
hopeless13118303hopeless
horseless1237213horseless
hueless1058823_hueless
iceless9219963_iceless
idealess935653idealess
isleless834853isleless
keelless12236193keelless
keyless1436163_keyless
kneelers12226213kneelers
laceless10239853laceless
legless838013_legless
lifeless11228143lifeless
limeless10249663limeless
lineless82711943lineless
loveless1168573loveless
maneless102812343maneless
mateless102711293mateless
moveless1367753moveless
nameless10248373nameless
needless9308333needless
nerveless1243933nerveless
netless739863_netless
noseless839513noseless
noteless839403noteless
orbless937493or_bless
orderless1044313orderless
paneless102611763paneless
peelers93615593_peelers
peeress939503_peeress
peerless1037513peerless
pegless1038053_pegless
pileless1088623pileless
pipeless12107663pipeless
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
precess11310863pr_ecess
preelect1249643preelect
preelects1356083preelects
preeners102712813preeners
prepress12137983prepress
priceless1336883priceless
rayless10239003_rayless
reales64934123_reale_s
realest73322433_realest
realness8410443_realness
recess8314263_r_ecess
reckless14257973_reckless
redlegs936823_redlegs
redness82012443_redness
redress82511873_redress
reefers103312593_reefers
reekers113613143_reekers
reelect911515633_reelect
reelects103110883_reelects
reeled74725533_reele_d
reeler63822573_reele_r
reels55333263_reel__s
reeves94721493_reeve_s
reflets103513153_reflets
reglets83512983_reglets
regloss8218023_regloss
regress82711453_regress
reinless8139433_reinless
relets64025673_r_elets
repress92712683_repress
restless82713163_restless
revelers113414133_revelers
ribless93410343_ribless
rimless9369363_rimless
rodless8310073_rodless
ruleless836633ruleless
runless72810423_runless
seedless9319513seedless
seeress7311573_seeress
sexless1467243_sexless
sheetless1235823sheetless
shoeless1137803shoeless
sleepless1144553sleepless
soleless8910033soleless
stateless937563stateless
stemless1036653stemless
strapless1135793strapless
streekers13195793streekers
streeled9267863streele_d
streels73811343streel__s
stressless942763stressless
strifeless1343213strifeless
stripeless1243283stripeless
styleless1243413styleless
tableless1145023tableless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tameness102411253tameness
tankless12267823tankless
tasteless935673tasteless
taxless1436903t_axless
tearless848713tearless
teels55726373t_eel__s
teemers95012903t_eemers
teeners74415453t_eeners
teepees939263t_eepees
teeters74018303t_eeters
teethless1243703teethless
teles54536003t__ele_s
teleses7313123t__eleses
telesis7310793t__elesis
tellers73717593t_ellers
tentless8229843tentless
tercelets1144813tercelets
terpeneless1361773terpeneless
terseness948403terseness
textless15245793textless
thawless1434083thawless
theelins1137643theelins
theelols1144413theelols
thowless1434613thowless
threadless1442473threadless
tintless8239863tintless
tipless92610063t_ipless
tiredness1036933tiredness
toadless936313toadless
tombless1236773tombless
toolless836343toolless
topless92511123t_opless
townless1135653townless
toyless10268713t_oyless
trackless15246723trackless
trailers82912923trailers
trailless935963trailless
travelers12266773travelers
trawlers113310203trawlers
trawleys14284383trawleys
treacles1039703treacle_s
treaders93311843treaders
treadlers1045893treadlers
treadles939703treadle_s
treaters83615843treaters
treble8311663treble__
trebled1038483treble_d
treddles1036263treddle_s
treelawn1142713treelawn
treelawns1242043treelawns
treelike1237003treelike
treens65317873tr_e_ens
trees55835763tr_e_e_s
treetops1045463treetops
trekkers1133803trekkers
trellis739873tr_ellis
trellises947023trellises
tremblers1334483tremblers
trembles1237353tremble_s
trespass1043383trespass
tress55423163tr___ess
tressels8367653tressels
tresses73719543tresse_s
trestles83012553trestle_s
trevets10499973tr_evets
trienes74118413triene_s
triflers113110213triflers
trifles103814823trifle_s
trigness968403trigness
trillers83613493trillers
trimness1067563trimness
triolets83410143triolets
triples94616873triple_s
triplets103510263triplets
triteness9310363triteness
trollers83211213trollers
trolleys11315693trolleys
trowelers12105263trowelers
trustless955953trustless
truthless1244033truthless
tugless837383t_ugless
turfless1135533turfless
tuskless1234213tuskless
tweedles1234113tweedle_s
tweeners11306243tweeners
tweeters11287143tweeters
tweezers20254383tweezers
tweezes19345703tweeze_s
twigless1293663twigless
unreelers9154743unreelers
useless7188423_useless
verbless1336033verbless
viceless1337983viceless
viewless1434033viewless
voteless1137493voteless
wageless1237173wageless
wakeless1536473wakeless
waveless1437483waveless
webless1237003_webless
weedless12287963weedless
wheelers14287733wheelers
wheelless1543763wheelless
wifeless14277483wifeless
wineless112711173wineless
wireless11249633wireless
yokeless1535303yokeless
zoneless1737823zoneless

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.186960704.3
2DLD Change Limit1461623118.95616320.0
3Display Results3113110.1232528.5
 (SQL Overall)1786913119.26519286.7
 
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.