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

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

69 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
excursionists228272(None) 
excursionist2173201excursionist_
exclusionists2263332exclusionists
exclusionist2154093exclusionist_
excursions1944323excursion___s
expansionists2292733expansionists
extortionists2074383extortionists
percussionists18102543percussionists
accordionists1861494accordionists
diversionists1763254diversionists
educationists1654344educationists
elocutionists1554314elocu_tionists
exclusivists2461724exclusi_vists
excursion1844614excursion____
excursiveness2554564excursivenes_s
expansionisms2482474expansionisms
expansionist2183434expansionist_
expressionists2363094expressionists
extortionist1975314extortionist_
fusionists1354474__fu_sionists
illusionists1253674illu_sionists
percussionist17123364percussionist_
perfusionists1863114perfu_sionists
secessionists1463334secessionists
abortionists1454975_abortionists
accordionist1761875accordionist_
arsonists947415___ars_onists
cartoonists1384405__cartoonists
crayonists1544135__c_rayonists
diffusionists2082265diffusionists
disunionists1352875disu_nionists
diversionist1654515diversionist_
divisionists1653275_divisionists
ecumenists14144205e_cu__menists
educationist1555265educationist_
elocutionist1455095elocu_tionist_
evolutionists16145715evolutionists
excisions1846385exc_ision___s
exclusions1945015exclusion___s
exclusivisms2661515exclusi_visms
exclusivist2362235exclusi_vist_
excursivenesses2794735excursivenesses
excursuses1951495excurs___uses
exhibitionists2662515exhibitionists
expansionism2392685expansionis_m
expansionistic2591745expansionistic
expressionisms2562605expressionisms
expressionist2264045expressionist_
expulsions1943835expulsion___s
exteriorises1954215exter_iorises
extrusions1745165extrusion___s
fictionists1655995fic__tionists
fusionisms1543995__fu_sionisms
fusionist1246075__fu_sionist_
illusionisms1452925illu_sionisms
illusionist1154935illu_sionist_
incursions1244835incursion___s
intuitionists1363895intuitionists
perfusionist1753905perfu_sionist_
precisionists1754635precisionists
receptionists1754775receptionists
recursions1245405recursion___s
reductionists1654655reductionists
reunionists1154565_reu_nionists
revisionists15144805_revisionists
secessionisms1662775secessionisms
secessionist1454755secessionist_
unionists946215___u_nionists
vacationists1754585vac_ationists

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 Filter1786911247900.406440125.6
2DLD Change Limit124790698.73314289.5
3Display Results69690.0461500.0
 (SQL Overall)178691699.18519454.7
 
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.