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

61 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
secaloses114691(None) 
secalose1046961secalose_
escalopes1344772escalopes
sucraloses1273592sucraloses
alkaloses13144853alkaloses
calloses10313393__calloses
closes85425593__c_loses
cycloses1538183cyc_loses
decalogs1245633decalo_gs
decalogues1443253decalogues
declasses1246443declasses
encloses10911063_encloses
escalades1244403escalades
escalates1148823escalates
escalope1244523escalope_
escaloped1443983escaloped
escalops1244673escalo_ps
escaroles1145283escaroles
focalises14139953focalises
hematoses1448453hematoses
incloses101610533inc_loses
keratoses1346093keratoses
legaleses1044393legaleses
legalises1038563legalises
levuloses1243323levuloses
localises111411463localises
megadoses1344663megadoses
megalopses1543553megalopses
melanoses1147303melanoses
metalises11315073metalises
necroses10310573nec_roses
penalises11912773penalises
peploses1269473pe_ploses
petasoses1145443petasoses
realises82420183re_alises
rechooses14107623rechooses
recluses105111733rec_luses
saroses73619333s__aroses
scalades11258803s_calades
scalages113010253s_calages
scalares103210983s_calares
scales84529313s_cal__es
scapose1147753s_capose_
scolioses1155613s_colioses
seahorses1246163se_ahorses
secludes1134953sec_ludes
selenoses947463selenoses
semioses10611013se_mioses
sepalous1047523sepalo_us
serialises10811563serialises
setulose884843setulose_
socialises1258253socialises
specialises1546003specialises
sucralose1193713sucralose_
sucroses1039943suc_roses
sycamores1642873sycamores
sycoses1249133syc__oses
trehaloses1343363trehaloses
uncloses10910943unc_loses
vocaleses14145323vocaleses
vocalises141710333vocalises

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.423422437.4
2DLD Change Limit148641617.04621095.8
3Display Results61610.0302033.3
 (SQL Overall)178691617.49923828.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.