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

127 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
improvisations215253(None) 
improvisation2052991improvisation_
improvisational2261652improvisational
improvisators20172612improvisat_ors
improvisator19152653improvisat_o_r
improvisatore20152363improvisat_ore
improvisatores21171703improvisatores
improvisatori20162173improvisat_ori
improvisatory23152433improvisat_ory
approximations2761964approximations
imbrications1845684imbr__ications
implications1847024imp__lications
importations16156144imp_o_rtations
impositions1546034imp_o__sitions
imprecations1846274impr__ecations
imprecisions1853924imprecis__ions
impregnations1853774impr_egnations
improvising1943844improvis__i_ng
improvisors1882514improvis___ors
provisions1547214__provis__ions
provocations1956874__provocations
reprovisions1753774reprovis__ions
abbreviations202145065abbrevi_ations
ammoniations1645415am_moni_ations
amortizations2456465amor_tizations
amplifications2384755amplifications
appreciations1964765appreci_ations
approbations1854245appro__bations
appropriations1763175appropriations
approximation2652235approximation_
bloviations1643755__blovi_ations
brominations1646755__brominations
caprifications2385565caprifications
colonisations15216175_colonisations
depravations1885375deprav__ations
depreciations1846575depreci_ations
deprivations1897925depr__ivations
dimerizations2548545dimer__izations
emarginations1674155emar_ginations
embolizations2646725em_bolizations
embrocations1843985embro__cations
epoxidations2243645_ep_oxidations
erotizations21411005__erotizations
exploitations2254215explo_itations
expropriations2553325expropriations
extravasations2462775extravasations
fimbriations1943355fimbr__i_ations
gravitations1644765__gravitations
idolizations2247465i__dolizations
illuviations1553055i_lluvi_ations
imaginations1546345im__aginations
imbrication1746465imbr__ication_
imitations1259965im____itations
immoderations1853075im_moderations
immolations1545475im_mo__lations
immunizations26115345im_munizations
impartations16135435imp__artations
impersonations1863655impersonations
impetrations1645445imp__etrations
implantations1753245imp_lantations
implication1747775imp__lication_
implosions1444025implo__s__ions
importation15147125imp_o_rtation_
imposition1446535imp_o__sition_
imprecation1746545impr__ecation_
imprecision1753905imprecis__ion_
impregnation1754015impr_egnation_
impresarios1552375impr__esario_s
impressions1546825impr__es_sions
imprisons1344915impr__is___ons
improbities1754695improbi__ti_es
improvisatorial2281355improvisatorial
improvisers1892775improvis___ers
improvises1784595improvis____es
improvisor1782765improvis___o_r
imputations1546355imp___utations
incriminations18105135incriminations
ingratiations1455155ingrati_ations
innovations1445265i_nnov__ations
intoxications22135685i_ntoxications
intromissions15142795intromis_sions
invitations1449055i___nvitations
iodinations1268845i___odinations
ionizations2049895i___onizations
irradiations1394885i_rradi_ations
irrigations1246945i__r_rigations
irritations1147835i__r_ritations
marginations1546465_mar_ginations
marinations13411285_mar__inations
memorizations2649535_memorizations
micropulsations21102245micropulsations
moralizations24410815_moralizations
motivations1647095_m__otivations
motorizations2449125_motorizations
optimisations17153445_optimisations
patronizations2576195patronizations
predications17411185__predications
prelibations16127625__prelibations
previsions1547735__previs__ions
privations15310105__pr__ivations
probations14311085__pro__bations
procreations1647275__procreations
procurations1647405__procurations
profanations17175255__profanations
prohibitions1953835__prohibitions
pronations12314035__pro__nations
propagations1745555__propagations
propitiations1756205__propitiations
propositions16108315__propositions
prorations12314465__pro__rations
prorogations1556725__prorogations
prostrations1449775__prostrations
protestations1555815__protestations
protonations1449075__protonations
provision1447635__provis__ion_
provitamins1853565__provitami_ns
provocation1847355__provocation_
reprobations1647775repro__bations
reprovision1653715reprovis__ion_
simplifications2463195simplifications
spoliations1347695_sp_oli_ations
strobilations1553885_strobilations
superovulations2063365superovulations
temporizations2785755temp_orizations
terrorizations2356175terrorizations
unionisations1353205_unionisations
vaporizations2776965vap_orizations

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 Limit950241277.96611928.7
3Display Results1271270.1101154.5
 (SQL Overall)1786911278.45221141.9
 
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.