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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

44 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
improvisatory2315243(None) 
improvisator19152651improvisator_
improvisatore20152361improvisatore
improvisatori20162171improvisatori
improvisators20172611improvisators
improvisatores21171702improvisatores
improvisation2052993improvisation
improvisations2152533improvisations
improvisatorial2281353improvisatorial
improvisor1782763improvis__or_
improvisors1882513improvis__ors
imprecatory2053504impr__ecatory
improvisational2261654improvisational
improviser1773314improvis__er_
improvisers1892774improvis__ers
provisory1744354__provis__ory
appreciatory2153195appreci_atory
approbatory2062895appro__batory
depreciatory2063415depreci_atory
impostor12265485imp_o__s_tor_
impostors13305655imp_o__s_tors
impregnator1652825impr_egnator_
impregnators1752535impr_egnators
imprimatur1651835impr__imatur_
imprimaturs1751535impr__imaturs
improbity1843645improbi__t__y
improvidently2461825improvidently
improvise1674855improvis____e
improvised1873565improvis___ed
improvises1784595improvis___es
improvising1943845improvis__ing
incriminatory2062885incriminatory
ingratiatory1662485ingrati_atory
innovatory1653165i_nnov__atory
invitatory1644785i___nvitatory
predicatory1945565__predicatory
prehistory1845325__prehis_tory
preovulatory2052195__preovulatory
probatory1647115__pro__batory
profanatory1952995__profanatory
prohibitory2152575__prohibitory
promissory1752775__promis_sory
propitiatory1963385__propitiatory
reprobatory1853665repro__batory

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.423422437.4
2DLD Change Limit124790449.18613584.8
3Display Results44440.0301466.7
 (SQL Overall)178691449.63918538.3
 
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.