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 “doubtless” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

63 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
doubtless124331(None) 
countless1146372countless
dauntless1033662dauntless
debtless1135652d_ebtless
doublers11288502doub_lers
doubles103113352doub_le_s
doublets11257362doub_lets
doubters11257392doubt_ers
doubtlessly1752472doubtlessly
ductless11196312d_uctless
dustless9328352d_ustless
outbless1037962_outbless
boltless10338283bo_ltless
bootless103410983bo_otless
boughless1543873boughless
boundless1235183boundless
coatless1039693co_atless
costless10310003co_stless
countess103710053count_ess
crustless1155403crustless
doorless936713do_orless
dottles83912283do_ttle_s
double94013993doub_le__
doubled11289953doub_le_d
doubleness1345783doubleness
doubler103110083doub_le_r
doublet103914033doub_le_t
doubted11307483doubt_e_d
doubter10298353doubt_e_r
doubtfulness1853683doubtfulness
doubts968733doubt___s
dourness947683dou_rness
dowerless1344013dowerless
downless1236363do_wnless
faultless1243163faultless
footless113710803fo_otless
fruitless1244163fruitless
gustless9287683_gustless
gutless82610713_gu_tless
houseless1237463houseless
hurtless11307783_hurtless
jobless16237563jo_b_less
jointless1634323jointless
loftless1135903lo_ftless
mouthless1444713mouthless
nounless837253nou_nless
orbless937493_orb_less
outlets73616363_ou_tlets
poetless1038723po_etless
pointless1135703pointless
portless10310643po_rtless
rootless83910443ro_otless
roubles93413513roub_le_s
rustless83510243_rustless
soulless8218763sou_lless
soundless1035533soundless
soupless10268463sou_pless
spoutless1134243spou_tless
subtlest10511363_subtlest
tombless1236783tomb_less
trustless955953trustless
tubeless1037023_tubeless
woundless1334033woundless

Search took 7 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.423422437.4
2DLD Change Limit148641636.40623203.4
3Display Results63630.0302100.0
 (SQL Overall)178691636.85926052.0
 
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.