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

147 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
waistless123509(None) 
listless8269262_listless
mastless102610022ma_stless
pastless102411202pa_stless
taintless935732taintless
waisters113811522waist_ers
waitress1135222wai_tress
warstlers12284712warstlers
warstles11368802warstle_s
wartless11279922wa_rtless
wattless11268722wa_ttless
whistlers1595162whistlers
whistles14108212whistle_s
wishless1435992w_ishless
witless103310982w_i_tless
wristlets1244472wristlets
aidless83612073_ai_dless
aimless93610813_ai_mless
airless73712043_ai_rless
aisles64721143_ais_le_s
artless73712513_a_rtless
ashless10318453_a_shless
assetless943573_assetless
baseless1099563ba_seless
blissless1142633blissless
bristles101510433bristle_s
cashless1336773ca_shless
castles94917733ca_stle_s
causeless1135193causeless
costless10310003_costless
crestless1146783crestless
crustless1155403crustless
dauntless1033663dauntless
distress9311713_distress
dustless9328353_dustless
epistlers1154113epistlers
epistles1047783epistle_s
exitless1534883exi_tless
faintness1235833faintness
faithless1543903faithless
fastness11238763fa_stness
fatless103212203fa__tless
faultless1243163faultless
feastless1235043feastless
fishless1436413_fishless
frostless1235743frostless
gainless9117403gai_nless
gasless8319013ga_s_less
gastness9278473ga_stness
giftless1245173_giftless
gristles9189203gristle_s
guiltless1043023guiltless
gustless9287683_gustless
hairless1157413hai_rless
haltless11308443ha_ltless
hatless103813443ha__tless
hiltless11297123_hiltless
hitless103211193_hi_tless
istles62814983__istle_s
jointless1634323jointless
lintless82710013_lintless
mailless10248583mai_lless
massless10277113ma_ssless
matless93014043ma__tless
mistress10310703_mistress
moistness1146343moistness
noiseless945553noiseless
painless10108343pai_nless
paisleys1333343pais_leys
passless10247223pa_ssless
pastness102510503pa_stness
pointless1135703pointless
printless1137513printless
rainless8129703rai_nless
resistless1043173resistless
restless82713163_restless
riftless1136943_riftless
riskless1235763_riskless
rustless83510243_rustless
sailless82410373sai_lless
saltless8259343sa_ltless
sashless1136603sa_shless
shiftless15265303shiftless
shirtless12266413shirtless
shitless11249243shi_tless
skirtless13254423skirtless
slitless8268143sli_tless
tactless10288463ta_ctless
tailless8239083tai_lless
tasteless935673ta_steless
thistles1198233thistle_s
tintless8239863_tintless
trustless955953trustless
vastness11257293va_stness
vestless11258843_vestless
vistaless1254573_vistaless
wageless1237173wa_geless
wailers103916803wai__lers
waisted114210943waist_e_d
waister103812383waist_e_r
waistings1352710763waistings
waistline1244173waistline
waistlines1343893waistlines
waists97415453waist___s
waiters104218623wai_t_ers
waitlist1147743wai_tlist
waitlists1244603wai_tlists
wakeless1536473wa_keless
wardless12249303wa_rdless
warless104015103wa__rless
warslers11328073wars_lers
warsles103413643wars_le_s
warstle10328013warstle__
warstled12286123warstle_d
warstler11275933warstle_r
wasters104026593wa_st_ers
wastes96224883wa_st_e_s
wastrels1136203wa_strels
waterless1238013waterless
wattles103814073wa_ttle_s
waveless1437483wa_veless
wayless13308243wa__yless
weightless1742713weightless
wheatless1534003wheatless
whistle13107533whistle__
whistled1595783whistle_d
whistler1496313whistle_r
whittlers1594333whittlers
whittles1496673whittle_s
wickless1736083w_ickless
wifeless14277483w_ifeless
wigless11359673w_i_gless
windless123310863w_indless
wineless112711173w_ineless
wingless122910023w_ingless
winless103212283w_i_nless
wintles103414983w_intle_s
wireless11249633w_ireless
wiseness112010753w_iseness
witness103010013w_i_tness
wrastles11328933wrastle_s
wrestlers12306103wrestlers
wrestles113310063wrestle_s
wristiest1237753wristiest
wristlet1138643wristle_t
yeastless1234053yeastless
zestless17247433_zestless

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411477.28020417.7
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.49923828.6
 
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.