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

47 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
expansionisms248247(None) 
expansionism2392681expansionism_
expansionists2292731expansionists
expansionist2183432expansionis_t
expansionistic2591743expansionistic
expansions1944153expansion___s
expressionisms2562603expressionisms
exclusionists2263334exclusionists
excursionists2282724excursionists
expansion1844444expansion____
expansional2052804expansion__al
expansionary2462104expansion_ary
expansiveness2554304expansivenes_s
expatriatisms2462284expatriatisms
expressionism2463364expressionism_
expressionists2363094expressionists
creationisms1685525crea_tionisms
deviationisms1953895devia_tionisms
diffusionisms2281895diffusionisms
divisionisms1862785_divisionisms
epigonisms1544085e_p__igonisms
eudaemonisms17132265euda_emonisms
eudaimonisms17131875euda_imonisms
evolutionisms18124645evolutionisms
exclusionist2154095exclusionis_t
exclusivisms2661515exclusi_visms
excursionist2173205excursionis_t
exhibitionisms2882065exhibitionisms
expansivenesses2794525expansivenesses
expansivities2582485expansivities
expansivity2652365expansi_vi_ty
expatriatism2362825expatriatism_
expensiveness2555585expensivenes_s
explosions19134665explosion___s
expressionist2264045expressionis_t
expulsions1943835expulsion___s
extensions1746135extension___s
extortionists2074385extortionists
fusionisms1543995___fusionisms
illusionisms1452925_illusionisms
impressionisms2062365impressionisms
padronisms1544895__pa_dronisms
passivisms1743715__passi_visms
patriotisms1553825__patriotisms
revisionisms17143875_revisionisms
secessionisms1662775secessionisms
unionisms1145885___un_ionisms

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 Limit124790479.19013578.9
3Display Results47470.0301566.7
 (SQL Overall)178691479.62618563.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.