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

98 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
trellises94702(None) 
trellised1044651trellised
creolises1157892creolises
realises82420182_realises
tallises82713262t_allises
tellies73820502t_elli_es
treatises9310372treatises
trellis739872trelli__s
trollies8310232trolli_es
bellies94023723_belli_es
brewises1337213bre_wises
brollies1039533brolli_es
cellists1038563_cellists
challises14358783challises
creolise1037863creolise_
creolised1255203creolised
creolizes2056583creolizes
cullises103111313_cullises
dellies83622213_delli_es
duellists1053753duellists
ellipses1044343__ellipses
fellies104119743_felli_es
idealises1047783idealises
jellies143816533_jelli_es
kellies113516853_kelli_es
nellies73418723_nelli_es
niellists944793niellists
obelises1039103obe_lises
pelvises1337273_pelvises
precises123218333pre_cises
prelives13310383pre_lives
premises123018273pre_mises
preslices1338213preslices
previses133814283pre_vises
proclises1339543proclises
rallies73823343_ralli_es
realise73021813_realise_
realised92214533_realised
realiser82512563_realiser
realisers9248323_realisers
realisms102212163_realisms
realists83014843_realists
realizes173116843_realizes
reclines103718543_reclines
recluses105111733_recluses
redlines93916083_redlines
reflies104418533_refli_es
relapses1038033_relapses
releases8313343_releases
relies65036423_re_li_es
relines75331323_re_lines
relishes11311953_re_lishes
relists73817053_re_lists
relives104619443_re_lives
remises93423483_re_mises
replies94521043_repli_es
reprises102615463_reprises
reraises8415643_reraises
rerises73525883_re_rises
revises104220533_re_vises
stellites938123stellites
sterilises1048253sterilises
tallies73624603t_alli_es
teleses7313123t_e_leses
televises1246353t_elevises
tennises82810133t_ennises
thalluses1243903thalluses
thelitises1354873thelitises
theorises1247813theorises
tillites8312833t_illites
totalises9311783totalises
tramlines1139843tramlines
traplines11310373traplines
travoises1245863travoises
treaties8316983treati_es
treatise8311103treatise_
trebles9311443trebl__es
treeless839283treeles_s
treelike1237003treelike_
trehaloses1343363trehaloses
treillages1143463treillages
trellising1144663trellising
tremolites1256053tremolites
trendies9312213trendi_es
trephines1448483trephines
tresses73719543tre__sses
trevallies1343463trevalli_es
trilbies1037693trilbi_es
trillions947183trillions
trilliums1144333trilliums
triplites1148283triplites
troilisms1146413troilisms
troilites948433troilites
troiluses944553troiluses
trollied935893trolli_ed
trollings10286693trollings
trotlines939103trotlines
wellies103719073_welli_es

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.436409841.7
2DLD Change Limit148641987.20320636.0
3Display Results98980.0462130.4
 (SQL Overall)178691987.68523251.9
 
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.