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

54 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
illustrational146155(None) 
illustration1253512illustration__
illustrations1353152illustration_s
illustrating1372723illustrati_n_g
fluctuational1861234_fluctuational
illusional1053404illus____ional
illustrative1562504illustrati__ve
illustratively2061594illustratively
illustrator1152114illustrat_o__r
illustrators1252004illustrat_o_rs
lustration1048354__lustration__
lustrations1147624__lustration_s
salutational1253324salu_t_ational
abstractional1753265__abstractional
acculturational1971665acculturational
arbitrational1553185_arbitrational
demonstrational1862635demonstrational
dilatational1352775dil_at_ational
frustration1444815_frustration__
frustrations1544535_frustration_s
gestational1245115__gest_ational
illumination1455165illumination__
illuminations1554445illumination_s
illustrate1073445illustrat____e
illustrated1262735illustrat___ed
illustrates1173365illustrat___es
illustrious1152315illustr__io_us
illustriously1661905illustr__iously
illuviation1453575illu_viation__
illuviations1553055illu_viation_s
immigrational1851935i_mmigrational
incantational1553565incant_ational
insertional1147465i__nser_tional
inspirational1554415i_nspirational
instructional1555095i__nstructional
investigational1961935investigational
invitational1554905i_nvit_ational
irrational1047215i____rrational
irrotational1254025i_rrot_ational
lactational1344655__lact_ational
levitational1553635_levit_ational
librational1344555__l_ibrational
limitational1453545_limit_ational
lustrating1147785__lustrati_n_g
maturational1454185matu__rational
mutational1246515__mu_t_ational
nutational1047045__nu_t_ational
nutritional1154785__nu_tritional
orchestrational2071875orchestrational
reputational1474585repu_t_ational
stational948515____st_ational
subrational1345505__su_brational
ultrarational1363515_ultrarational
valuational1444055valu___ational

Search took 9 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 Filter178691950240.360496363.9
2DLD Change Limit95024548.00011878.0
3Display Results54540.0461173.9
 (SQL Overall)178691548.40621257.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.