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

284 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
ventless1124905(None) 
eventless1244601eventless
tentless8229841tentless
vestless11258841vestless
beatless103311592beatless
beltless10297712beltless
debtless1135652debtless
endless839832_endless
feetless1137382feetless
gentles83714342gentle_s
gentlest93410572gentlest
heatless113011462heatless
lensless835582lensless
lintless82710012lintless
meatless103410862meatless
netless739862ne_tless
peltless10267372peltless
restless82713162restless
scentless1135112scentless
seatless83213002seatless
textless15245792textless
tintless8239862tintless
veinless11136262veinless
venters103717732vent_ers
venules104011482venule_s
verbless1336032verbless
zestless17247432zestless
accentless1442563accentless
antlers74014743_antlers
artless73712513_artless
awnless1035923awn_less
beakless14297383beakless
beamless12327003beamless
bedless1039703be_dless
beefless1335493beefless
beetlers1037393beetlers
beetles9312083beetle_s
benchless1644153benchless
blotless10347153blotless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
bootless103410983bootless
cantles94721413cantle_s
centerless1245003centerless
centers94420603cent_ers
centeses1079443cent_eses
centesis1058143cent_esis
centiles103615813centile_s
centners1057243centners
centres93817123centre_s
clientless1272493clientless
coatless1039693coatless
costless10310003costless
countless1146373countless
crestless1146783crestless
dauntless1033663dauntless
deathless1335223deathless
deedless10318253deedless
deftness1236303deftness
depthless1542753depthless
dewless1137473de_wless
ductless11196313ductless
dustless9328353dustless
earless74316073_earless
eggless935663_eggless
egoless836983_egoless
entases72816273_entases
enters64425643_ent_ers
entrees71813773_entrees
evenness1135543even_ness
exitless1534883exitless
eyeless1058053_eyeless
fangless1237663fangless
fatless103212203_fatless
fearless1137873fearless
feastless1235043feastless
feckless17225783feckless
feeless103511103fe_eless
fenceless1444163fenceless
fernless1136063fernless
fettles103912733fettle_s
finless102810783fin_less
footless113710803footless
fretless1138063fretless
frontless1235403frontless
gantlets9308903gantlets
gearless937373gearless
gentes75324163gent_e_s
gentiles93713523gentile_s
gentilesse1142543gentilesse
gentle74014513gentle__
gentled9389093gentle_d
gentleness1145593gentleness
gentler8378953gentle_r
giftless1245173giftless
gunless8299633gun_less
gustless9287683gustless
gutless82610713_gutless
haltless11308443haltless
handless123512063handless
hantles104117513hantle_s
hatless103813443_hatless
headless12289863headless
heartless1236393heartless
heathless1535593heathless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helmless1334273helmless
helpless1335063helpless
henleys1334843hen_leys
herbless1336663herbless
hiltless11297123hiltless
hitless103211193_hitless
huntress1144833huntress
hurtless11307783hurtless
inkless11348713_inkless
innless7288293_innless
inventress1343623inventress
jointless1634323jointless
keelless12236193keelless
kentes105118653kent_e_s
kettles113411613kettle_s
keyless1436163ke_yless
kindless13289243kindless
kingless13288693kingless
kinless113310273kin_less
knotless1264573knotless
landless94011173landless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013le_gless
lineless82711943lineless
listless8269263listless
loftless1135903loftless
maneless102812343maneless
manless93012933man_less
mantles94820703mantle_s
mantlets104611203mantlets
mastless102610023mastless
matless93014043_matless
mealless10288363mealless
meetness1036653meetness
menseless1145203menseless
mentalese1146323mentalese
mentaleses1245953mentaleses
mentees93214503ment_ees
meritless1144593meritless
mettles94115023mettle_s
mindless11319443mindless
neatness839153neatness
neckless14236433neckless
needless9308333needless
nestlers8359223nestlers
nestles73015463nestle_s
nettlers8307513nettlers
nettles73214083nettle_s
newsless1134533newsless
overtness1238223overtness
paneless102611763paneless
parentless1244453parentless
pastless102411203pastless
peakless14236683peakless
peerless1037513peerless
pegless1038053pe_gless
penniless1144013penniless
pentoses10312893pentoses
pertness10310093pertness
pestles93217693pestle_s
pettles93916483pettle_s
pintles94118723pintle_s
pleatless1134613pleatless
plotless10256793plotless
poetless1038723poetless
pointless1135703pointless
portless10310643portless
printless1137513printless
rankless12268233rankless
reckless14257973reckless
reinless8139433reinless
relentless1043703relentless
renters74224813rent_ers
rentes65431193rent_e_s
rentiers83311763rentiers
restress82511773restress
riftless1136943riftless
rindless92510193rindless
rootless83910443rootless
rungless956733rungless
runless72810423run_less
rustless83510243rustless
saltless8259343saltless
sandless93212343sandless
seamless10238723seamless
seedless9319513seedless
selfless1135013selfless
seniles72618023senile_s
senseless945973senseless
settlers8289023settlers
settles73916003settle_s
sexless1467243se_xless
sheetless1235823sheetless
shitless11249243shitless
sinless73014213sin_less
slitless8268143slitless
solventless1451273solventless
songless9218823songless
sonless72612613son_less
spotless1037043spotless
sunless73013693sun_less
tactless10288463tactless
taintless935733taintless
talentless1042803talentless
tankless12267823tankless
tearless848713tearless
teethless1243703teethless
tenantless1043053tenantless
tenters73921103tent_ers
tentiest82115613tentiest
termless1036233termless
toneless8610393toneless
tuneless837913tuneless
unless62413073_un_less
vastness11257293vastness
vealers103214293ve_alers
veilers103911823ve_ilers
veinlets11144833veinlets
veinules1135913veinule_s
veinulets1243093veinulets
vendees114011453ven_dees
venders113717003ven_ders
vendues11318623vendue_s
veneers103710293ven_eers
venenes102712133venene_s
venges104015153ven_ge_s
venialness1344603venialness
venines103516613venine_s
venires103012453venire_s
venomers1336703venomers
ventages12119773ventages
ventails1139823ventails
vented104617923vent_e_d
venter94218723vent_e_r
ventrals112910003ventrals
vents86125933vent___s
venturers1245523venturers
ventures11311493ventures
venturis1138193venturis
venues95115203ven_ue_s
venule94411763venule__
venulose1144083venulose
venulous1145713venulous
venuses103111413venuse_s
vestees103513173vest_ees
vetoers10359473ve_toers
vetoes92914083ve_toe_s
vetters104016323ve_tters
viceless1337983viceless
victress1344523victress
viewless1434033viewless
vintners1134573vintners
vistaless1254573vistaless
vittles103211113vittle_s
voteless1137493voteless
votress1035483v_otress
vowless13246603v_owless
wartless11279923wartless
wattless11268723wattless
webless1237003we_bless
weedless12287963weedless
weldless12285813weldless
wetness10277723we_tness
wheatless1534003wheatless
windless123310863windless
wineless112711173wineless
wingless122910023wingless
winless103212283win_less
wintles103414983wintle_s
witless103310983_witless
yeastless1234053yeastless
yentes95517603yent_e_s
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 Filter1786911461620.436409841.7
2DLD Change Limit1461622846.95321021.4
3Display Results2842840.1262254.0
 (SQL Overall)1786912847.51523777.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.