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

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

124 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
improvisational2261651improvisational_
improvisation2052993improvisation___
improvisations2152533improvisation__s
improvisatorial2281354improvisatorial_
improvisator19152655improvisat_o___r
improvisatore20152365improvisat_o__re
improvisatores21171705improvisat_o_res
improvisatori20162175improvisat_o__ri
improvisators20172615improvisat_o__rs
improvisatory23152435improvisat_o__ry
provisional1655465__provis__ional_
provisionals1753765__provis__ionals
gravitational1762556__gravitational_
improvising1943846improvis__i_n__g
innovational1553836i_nnov__ational_
invitational1554906i___nvitational_
invitationals1652746i___nvitationals
irrotational1254026i_rro__tational_
motivational1753916_m__otivational_
previsional1655326__previs__ional_
prevocational2054016__prevocational_
probational1547086__pro__bational_
progestational1762756__progestational_
propositional1755246__propositional_
provisionally2163166__provis__ionally
provisionary2073246__provis__ionary
appositional1683947_appo__sitional_
approximation2652237approximation___
approximations2761967approximation__s
aspirational1455007asp___irational_
associational1552937_associ_ational_
compensational2073527comp__ensational_
compositional1974057comp_o__sitional_
consociational1853557consoci_ational_
denominational1752547_denominational_
depositional1554627dep_o__sitional_
derivational1654267_der__ivational_
dispensational1762507disp__ensational_
dispositional1653747disp_o__sitional_
disproportional2071927dispro_portional_
explorational2252557explo__rational_
expositional2153947exp_o__sitional_
gravitationally2271847__gravitationally
imbibitional1861707im___bibitional_
imbrication1746467imbr__ication___
imbrications1845687imbr__ication__s
immigrational1851937im__migrational_
implication1747777imp__lication___
implications1847027imp__lication__s
impolitical1753337imp_oli__ti_cal_
importation15147127imp_o_rtation___
importations16156147imp_o_rtation__s
imposition1446537imp_o__sition___
impositions1546037imp_o__sition__s
imprecation1746547impr__ecation___
imprecations1846277impr__ecation__s
imprecision1753907imprecis__ion___
imprecisions1853927imprecis__ion__s
impregnation1754017impr_egnation___
impregnations1853777impr_egnation__s
impressionable2062377impr__es_sionable
improvidently2461827improvi___dently
improvisor1782767improvis___o___r
improvisors1882517improvis___o__rs
inclinational1553937i__nclinational_
indicational1545757i___ndicational_
informational1854347i_nfo_rmational_
inquisitional2272837i__nquisitional_
inspirational1554417i__nspirational_
intonational1256007i_nto__national_
introspectional1972637introspectional_
investigational1961937investigational_
invocational1754417i___nvocational_
irrational1047217i__r___rational_
irrationals1154737i__r___rationals
levitational1553637___levitational_
limitational1453547lim____itational_
mediational1445647_m__edi_ational_
migrational1444747migr____ational_
motivationally2262497_m__otivationally
multinational1553767_m_ultinational_
multinationals1662227_m_ultinationals
navigational1653297___navigational_
oppositional1683847_oppo__sitional_
ovational1246857____ov__ational_
perorational1446397_pero__rational_
populational1654417__p_opulational_
positional1247907__p_o__sitional_
preoperational1853247__preoperational_
prepositional1755197__prepositional_
previsionary2083307__previs__ionary
probationally2054097__pro__bationally
probationary1953227__pro__bationary
processional1665397__proces_sional_
processionals1754147__proces_sionals
productional1794717__pro_ductional_
professional1754967__profes_sional_
professionals1864047__profes_sionals
projectional2355427__pro_jectional_
promotional1555637__pro__motional_
proportional1655817__pro_portional_
proportionals1764027__pro_portionals
provision1447637__provis__ion___
provisioned1753977__provis__ion_ed
provisioner1653797__provis__ion_er
provisioners1752817__provis__ioners
provisioning1883597__provis__ioning
provisions1547217__provis__ion__s
provocation1847357__provocation___
provocations1956877__provocation__s
radiational1245967___radi_ational_
reprovision1653717reprovis__ion___
reprovisioned1961617reprovis__ion_ed
reprovisioning2061627reprovis__ioning
reprovisions1753777reprovis__ion__s
rotational1048097___ro__tational_
speciational1654317_sp_eci_ational_
suppositional1763067suppo__sitional_
supranational1552997supr__anational_
suprarational1552927supr__arational_
terminational1553487_ter_minational_
unprofessional1962597unprofes_sional_
unprofessionals2072017unprofes_sionals
variational1444787_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 Limit950241248.50011179.3
3Display Results1241240.0931333.3
 (SQL Overall)1786911248.96919923.2
 
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.