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

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

108 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
improvisational226165(None) 
improvisation2052992improvisation__
improvisations2152532improvisation_s
improvisatorial2281353improvisatorial
improvisator19152654improvisat_o__r
improvisatore20152364improvisat_o_re
improvisatores21171704improvisat_ores
improvisatori20162174improvisat_o_ri
improvisators20172614improvisat_o_rs
improvisatory23152434improvisat_o_ry
provisional1655464__provis__ional
gravitational1762555__gravitational
improvising1943845improvis__i_n_g
innovational1553835i_nnov__ational
invitational1554905i___nvitational
irrotational1254025i_rro__tational
motivational1753915_m__otivational
previsional1655325__previs__ional
prevocational2054015__prevocational
probational1547085__pro__bational
progestational1762755__progestational
propositional1755245__propositional
provisionals1753765__provis__ionals
appositional1683946_appo__sitional
approximation2652236approximation__
approximations2761966approximation_s
aspirational1455006asp___irational
associational1552926_associ_ational
compensational2073526comp__ensational
compositional1974056comp_o__sitional
consociational1853546consoci_ational
denominational1752546_denominational
depositional1554626dep_o__sitional
derivational1654266_der__ivational
dispensational1762506disp__ensational
dispositional1653746disp_o__sitional
disproportional2071926dispro_portional
explorational2252556explo__rational
expositional2153946exp_o__sitional
imbibitional1861706im___bibitional
imbrication1746466imbr__ication__
imbrications1845686imbr__ication_s
immigrational1851936im__migrational
implication1747776imp__lication__
implications1847026imp__lication_s
impolitical1753336imp_oli__ti_cal
importation15147126imp_o_rtation__
importations16156146imp_o_rtation_s
imposition1446536imp_o__sition__
impositions1546036imp_o__sition_s
imprecation1746546impr__ecation__
imprecations1846276impr__ecation_s
imprecision1753906imprecis__ion__
imprecisions1853926imprecis__ion_s
impregnation1754016impr_egnation__
impregnations1853776impr_egnation_s
improvisor1782766improvis___o__r
improvisors1882516improvis___o_rs
inclinational1553936i__nclinational
indicational1545756i___ndicational
informational1854346i_nfo_rmational
inquisitional2272836i__nquisitional
inspirational1554416i__nspirational
intonational1256006i_nto__national
introspectional1972636introspectional
investigational1961936investigational
invitationals1652746i___nvitationals
invocational1754416i___nvocational
irrational1047216i__r___rational
levitational1553636___levitational
limitational1453546lim____itational
mediational1445646_m__edi_ational
migrational1444746migr____ational
multinational1553766_m_ultinational
navigational1653296___navigational
oppositional1683846_oppo__sitional
ovational1246856____ov__ational
perorational1446396_pero__rational
populational1654416__p_opulational
positional1247906__p_o__sitional
preoperational1853246__preoperational
prepositional1755196__prepositional
processional1665396__proces_sional
productional1794716__pro_ductional
professional1754966__profes_sional
projectional2355426__pro_jectional
promotional1555636__pro__motional
proportional1655816__pro_portional
provision1447636__provis__ion__
provisionally2163166__provis__ionally
provisionary2073246__provis__ionary
provisioned1753976__provis__ioned
provisioner1653796__provis__ioner
provisions1547216__provis__ion_s
provocation1847356__provocation__
provocations1956876__provocation_s
radiational1245956___radi_ational
reprovision1653716reprovis__ion__
reprovisioned1961616reprovis__ioned
reprovisions1753776reprovis__ion_s
rotational1048096___ro__tational
speciational1654316_sp_eci_ational
suppositional1763066suppo__sitional
supranational1552996supr__anational
suprarational1552926supr__arational
terminational1553486_ter_minational
unprofessional1962596unprofes_sional
variational1444776_var__i_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.376475242.0
2DLD Change Limit950241087.81312162.3
3Display Results1081080.0601800.0
 (SQL Overall)1786911088.24921662.1
 
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.