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

143 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
viewless143403(None) 
crewless1335402crewless
dewless1137472_dewless
sinewless1244362sinewless
thewless1433922thewless
tieless72512562tie_less
veinless11136262veinless
viceless1337982viceless
viewers1337172view_ers
viewiest1435852viewiest
viewlessly1952122viewlessly
vowless13246602v_owless
ageless8310343age_less
aidless83612073ai_dless
aimless93610813ai_mless
airless73712043ai_rless
aweless1038723awe_less
awless939263__awless
bedless1039703_bedless
beefless1335493beefless
bibless11439173bi_bless
bowless123310313_bowless
briefless1443613briefless
browless1346653browless
clawless1334123clawless
deedless10318253deedless
eyeless1058053eye_less
feeless103511103_feeless
feetless1137383feetless
fewness1335003_fewness
fiberless1444443fiberless
filmless1344553filmless
finless102810783fi_nless
fireless112810593fireless
fishless1436413fishless
flawless1434503flawless
fretless1138063fretless
giftless1245173giftless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
hideless12278713hideless
hiltless11297123hiltless
hipless12399923hi_pless
hitless103211193hi_tless
hiveless14227933hiveless
hueless1058823hue_less
iceless9219963_iceless
idealess935653idealess
inkless11348713_inkless
innless7288293_innless
ireless72312243_ireless
jawless1745653_jawless
keelless12236193keelless
keyless1436163_keyless
kindless13289243kindless
kingless13288693kingless
kinless113310273ki_nless
lawless1037033_lawless
legless838013_legless
lidless8309273li_dless
lifeless11228143lifeless
limbless12246313limbless
limeless10249663limeless
lineless82711943lineless
linerless936333linerless
lintless82710013lintless
lipless9259553li_pless
listless8269263listless
mewlers12288983_mewlers
milkless1434773milkless
mindless11319443mindless
needless9308333needless
netless739863_netless
newness1035703_newness
newsless1134533_newsless
peerless1037513peerless
pegless1038053_pegless
pileless1088623pileless
pipeless12107663pipeless
pithless13117023pithless
pitiless10127333pitiless
poetless1038723poetless
prebless1236823prebless
reinless8139433reinless
ribless93410343ri_bless
riderless1044903riderless
riftless1136943riftless
rimless9369363ri_mless
rindless92510193rindless
riskless1235763riskless
riverless1244943riverless
seedless9319513seedless
sexless1467243_sexless
sighless1276553sighless
sinless73014213si_nless
skewness1533763skewness
snowless1145623snowless
stemless1036653stemless
thawless1434083thawless
thowless1434613thowless
tideless9269083tideless
timeless10239543timeless
tintless8239863tintless
tipless92610063ti_pless
tireless82510263tireless
toeless72612393toe_less
treeless839283treeless
useless7188423use_less
vealers103214293v_ealers
veilers103911823v_eilers
veinlets11144833veinlets
ventless11249053ventless
verbless1336033verbless
vestless11258843vestless
victress1344523victress
viewed1345993view_e_d
viewer1237213view_e_r
viewier1334983viewie_r
viewings1533983viewings
views11489643view___s
vileness1139983vileness
vilest9416843vi__lest
violets102210003vi_olets
visorless1243143visorless
vistaless1254573vistaless
vitalness1245413vitalness
vittles103211113vittle_s
voiceless1444223voiceless
voteless1137493voteless
webless1237003_webless
weedless12287963weedless
wickless1736083wickless
wifeless14277483wifeless
wigless11359673wi_gless
windless123310863windless
wineless112711173wineless
wingless122910023wingless
winless103212283wi_nless
wireless11249633wireless
wishless1435993wishless
witless103310983wi_tless
zipless18276303zi_pless

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621438.22017781.3
3Display Results1431430.0632269.8
 (SQL Overall)1786911438.45321139.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.