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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
inscriptional1717351(None) 
inscription1544952inscription__
inscriptions1654502inscription_s
insertional1147463inser__tional
inspirational1554413inspirational
instructional1555093instructional
transcriptional1992243transcriptional
ascription1444994_ascription__
ascriptions1544984_ascription_s
conscription1855334conscription__
conscriptions1955004conscription_s
description1645374description__
descriptions1755404description_s
inclinational1553934in_clinational
informational1854344informational
inscriptive1853844inscripti__ve
inscriptively2362484inscriptively
institutional1353504institutional
insurrectional1662604insurrectional
interactional1557004interactional
international1357674international
intuitional1155294in_tui_tional
nutritional1154784_nutri_tional
unscriptural1661324unscript_ural
abstractional1753265abstractional
antirational1278495antir_ational
apparitional1652765appari_tional
aspirational1455005_aspirational
associational1552935associational
attritional1154245_attri_tional
coitional1148695___coi_tional
conceptional1856915conc_eptional
conscripting1954025conscripti_n_g
conservational1955345conservational
consociational1853555consociational
conspirational1853965conspirational
constructional1854765constructional
coscripting1843905coscripti_n_g
deceptional1654775_dec_eptional
disciplinal1653115disc_ipli_nal
dissertational1562575dissertational
distributional1762965distributional
encryption1753125en_cryption__
encryptions1852965en_cryption_s
exceptional2254445_exc_eptional
frictional1546255___frictional
imbibitional1861705imbibi_tional
incantational1553565incantational
inception1348695in_c_eption__
inceptions1448535in_c_eption_s
incretion1149055in_cr_etion__
incretions1248655in_cr_etion_s
indicational1545755in_dicational
inebriation1357245inebriation__
inebriations1456325inebriation_s
inflectional1754385in_flectional
infuriation1448245infuriation__
infuriations1547445infuriation_s
inhalational1553045in_halational
innovational1553835in_novational
inquisitional2272835inquisitional
inscribing1543855inscri_bi_n_g
insertion9410595inser__tion__
insertions10410345inser__tion_s
inspiration1348375inspiration__
inspirationally2072545inspirationally
inspirations1447305inspiration_s
instruction13137945instruction__
instructions14137815instruction_s
intentional11128845in__tentional
interjectional23195605interjectional
internationals1454245internationals
interregional1453765interregional
intersectional16146255intersectional
intonational1256005in_tonational
invitational1554905in_vitational
invocational1754415in_vocational
involutional1553575in_volutional
irrational1047215i___rrational
narrational1145445_n_arrational
nonfictional1754855_nonfictional
nonrational11109125_nonr_ational
observational1853185observational
perceptional1854905perc_eptional
positional1247905pos__i_tional
prescription18145345prescription__
prescriptions19135335prescription_s
proscription18124515proscription__
proscriptions19114165proscription_s
recreational1455175_recreational
scripting1437475__scripti_n_g
scriptural1452915__script_ural
speciational1654315spec_iational
subscription1853125subscription__
subscriptions1952825subscription_s
transcription1764075transcription__
transcriptions1863635transcription_s
uncritical1454985un_cri_ti_cal
unexceptional2462515unexceptional
unsensational1353665unsensational
variational1444785__variational

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.390458182.1
2DLD Change Limit1247901018.51614653.6
3Display Results1011010.0631603.2
 (SQL Overall)1786911018.96919923.2
 
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.