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

131 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
improvisation205299(None) 
improvisations2152531improvisations
improvisational2261652improvisational
improvisator19152652improvisat_or
improvisatore20152363improvisatore
improvisatori20162173improvisatori
improvisators20172613improvisators
improvisatory23152433improvisatory
approximation2652234approximation
imbrication1746464imbr__ication
implication1747774imp__lication
importation15147124imp_o_rtation
imposition1446534imp_o__sition
imprecation1746544impr__ecation
imprecision1753904imprecis__ion
impregnation1754014impr_egnation
improvisatores21171704improvisatores
improvisatorial2281354improvisatorial
improvising1943844improvis__ing
improvisor1782764improvis___or
provision1447634__provis__ion
provocation1847354__provocation
reprovision1653714reprovis__ion
abbreviation191175265abbrevi_ation
ammoniation1545905am_moni_ation
amortization2347205amor_tization
amplification2275185amplification
appreciation1855285appreci_ation
approbation1755025appro__bation
appropriation1653825appropriation
approximations2761965approximations
bloviation1544005__blovi_ation
bromination1547815__bromination
caprification2256055caprification
colonisation14176765_colonisation
depravation1785695deprav__ation
depreciation1747075depreci_ation
deprivation1788775depr__ivation
dimerization2449085dimer__ization
emargination1554865emar_gination
embolization2547415em_bolization
embrocation1744585embro__cation
epoxidation2144065_ep_oxidation
erotization20412065__erotization
exploitation2154705explo_itation
expropriation2453995expropriation
extravasation2363055extravasation
fimbriation1843555fimbr__i_ation
gravitation1545515__gravitation
idolization2147765i__dolization
illuviation1453575i_lluvi_ation
imagination1447195im__agination
imbrications1845685imbr__ications
imitation11510855im____itation
immoderation1753435im_moderation
immolation1446105im_mo__lation
immunization25115915im_munization
impartation15156105imp__artation
impersonation1764225impersonation
impetration1545905imp__etration
implantation1653355imp_lantation
implications1847025imp__lications
implosion1344345implo__s__ion
importations16156145imp_o_rtations
impositions1546035imp_o__sitions
imprecations1846275impr__ecations
imprecisions1853925imprecis__ions
impregnations1853775impr_egnations
impresario1452245impr__esario_
impresarios1552375impr__esarios
impression1447095impr__es_sion
imprison1244795impr__is___on
improbities1754695improbi__ties
improvise1674855improvis____e
improvised1873565improvis___ed
improviser1773315improvis___er
improvisers1892775improvis__ers
improvises1784595improvis___es
improvisors1882515improvis__ors
imputation1447125imp___utation
incrimination17145655incrimination
ingratiation1355805ingrati_ation
innovation1345645i_nnov__ation
intoxication21156355i_ntoxication
intromission14143205intromis_sion
invitation13410025i___nvitation
iodination1159985i___odination
ionization19411275i___onization
irradiation12105605i_rradi_ation
irrigation1147805i__r_rigation
irritation1048975i__r_ritation
margination1447435_mar_gination
marination12312815_mar__ination
memorization2549925_memorization
micropulsation2082515micropulsation
moralization23411615_moralization
motivation1548085_m__otivation
motorization2349705_motorization
optimisation16193945_optimisation
patronization2456755patronization
predication16412435__predication
prelibation15128665__prelibation
prevision1448005__previs__ion
privation14311175__pr__ivation
probation13412185__pro__bation
procreation1547955__procreation
procuration1548295__procuration
profanation16186105__profanation
prohibition1854265__prohibition
pronation11415705__pro__nation
propagation1646445__propagation
propitiation1656915__propitiation
proposition1588745__proposition
proration11415985__pro__ration
prorogation1447395__prorogation
prostration13410795__prostration
protestation1456365__protestation
protonation13510435__protonation
provisions1547215__provis__ions
provitamin1753305__provitami_n
provocations1956875__provocations
reprobation1548505repro__bation
reprovisions1753775reprovis__ions
simplification2353385simplification
spoliation1248425_sp_oli_ation
strobilation1454055_strobilation
superovulation1963545superovulation
temporization2675995temp_orization
terrorization2256665terrorization
unionisation1253445_unionisation
vaporization2697535vap_orization

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901318.08015444.3
3Display Results1311310.0931408.6
 (SQL Overall)1786911318.56320867.8
 
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.