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

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

92 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
captionless155250(None) 
actionless1244152_actionless
caprioles1376753caprio_le_s
captioned1445763caption_e_d
captions123813223caption___s
captiousness1647483captiousness
carbonless1444083ca_rbonless
cattiness112310633catti_n_ess
cautioners1244713caution_ers
cushionless1651473cushionless
emotionless1352853emotionless
motionless1243483_motionless
passionless1352873passionless
portionless1344023portionless
actioners1147724_action_ers
ambitionless1661664ambitionless
aptness9268574_apt__n_ess
artiness81615404_arti_n_ess
battiness11239844batti_n_ess
buttonless1242964_buttonless
cabrioles1376364cabrio_le_s
cabriolets1463374cabrio_lets
caginess11310304ca_gi_n_ess
cakiness1449554ca_ki_n_ess
campiness1537544campi_n_ess
candidness1444774candidn_ess
canniness1138644canni_n_ess
canoness1039394ca__non_ess
canticles1339184canti_cle_s
capitols12247334capito_l__s
capless114312764cap____less
caponiers1345734cap__oniers
capriole1276914caprio_le__
caprioled1464744caprio_le_d
capstones1347374capston_e_s
caption113513694caption____
captioning1545704caption_ing
captious122810574captio___us
captivates1745494captivate_s
captives1538624capti__ve_s
carioles10817074ca_rio_le_s
carrioles1169474carrio_le_s
cations94524144ca_tion___s
cautioned1245364caution_e_d
cautioner1145394caution_e_r
cautions103313184caution___s
cautiousness1447934cautiousness
chattiness1565124chatti_n_ess
chinless1337494c__hi_nless
cohesionless1752014cohesionless
craftiness1545754crafti_n_ess
curtainless1351934curtainless
emptiness1335374empti_n_ess
fathomless1842004fa_thomless
fattiness12239374fatti_n_ess
frictionless1752554frictionless
functionless1752414functionless
gainless9117404ga__i_nless
happiness1635994happi_n_ess
hastiness122410884hasti_n_ess
maltiness112910574malti_n_ess
matiness102114754ma_ti_n_ess
nappiness1335234nappi_n_ess
nastiness92310574nasti_n_ess
nattiness9239334natti_n_ess
optionees1144344_option_ees
painless10108344__pai_nless
pastiness112312354pasti_n_ess
patroness1137484pa_tron_ess
patternless1342284patternless
pensionless1353174pensionless
questionless2152004questionless
radiationless1481684radiationless
rainless8129704ra__i_nless
rapidness12155474rap_idn_ess
raptness1046734rapt__n_ess
rationales1049314ra_tionale_s
rationalness1254464ra_tionalness
saltiness93312114salti_n_ess
sappiness1337434sappi_n_ess
scantiness1236884scanti_n_ess
spinless10238704_sp_i_nless
tartiness92112054tarti_n_ess
tastiness92311144tasti_n_ess
tattiness9239414tatti_n_ess
tensionless1152674tensionless
traditionless1462084traditionless
vapidness15144424vap_idn_ess
vaporless1443164vap__orless
visionless1342964_visionless
wantonness1342844want_onness
weaponless1542004weap__onless

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 Filter1786911488190.440406115.9
2DLD Change Limit148819929.42015798.2
3Display Results92920.0501840.0
 (SQL Overall)178691929.91018031.4
 
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.