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

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

87 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
improvisers189277(None) 
improviser1773311improviser_
improvises1784591improvise_s
improvisors1882511improvisors
improvers1645042improv__ers
improvise1674852improvise__
improvised1873572improvise_d
improvisor1782762improvisor_
compromisers2051953compromisers
imposers12278463imp_o__sers
improver1545243improv__er_
improves1536123improv__e_s
improvident1952833improvident
improvisators20172613improvisators
improvising1943843improvising
promisers13268203__promisers
providers1535593__providers
appraisers1443504appr_aisers
apprisers1345054appr__isers
approvers16104914approv__ers
compromiser1952624compromiser_
compromises1954184compromise_s
dispraisers1443424dispr_aisers
disprovers16145284disprov__ers
embroiders1543524embro_iders
embroilers1443274embro_ilers
emprises12311004empr__ise_s
idolisers1043704i__dolisers
impairers1343714imp__airers
imparadises1653104imparadise_s
implorers13124414implo__rers
implosives1743054implosive_s
importers13247764imp_o_rters
importuners1552374importuners
imposer113310104imp_o__ser_
imposes113213684imp_o__se_s
imposters13347344imp_o_sters
impounders1542984imp_ounders
impoverishers236964imp_overishers
impowers15296824imp_o__wers
imprecise1545194imprecise__
imprecisely2052684imprecisely
impreses1238094impr__ese_s
impresses1338214impr_esse_s
imprinters1444144impr_inters
imprisons1344914impr__isons
improbities1754694improbities
improper1444534impro__per_
improve1435964improv__e__
improved1644774improv__e_d
improvement20104664improvement
improvements2173974improvements
improvidence2292074improvidence
improvidences2392044improvidences
improving1745414improvi__ng
improvisator19152654improvisator
improvisatore20152364improvisatore
improvisatores21171704improvisatores
improvisatori20162174improvisatori
improvisatory23152434improvisatory
improvs1435004improv____s
microliters1545804microliters
mortisers1186174_mor_tisers
pavisers13387444__p_avisers
poisers94214434__p_o_isers
praisers103410834__pr_aisers
previses133814284__previse_s
previsors14126484__previsors
profilers14236294__profilers
profiters14228314__profiters
promisees13246864__promisees
promiser122510674__promiser_
promises122916764__promise_s
promisors13236364__promisors
proposers13228524__proposers
prosers94219644__pro__sers
provers123817794__prov__ers
provider1436704__provider_
provides1439884__provide_s
provisoes1446654__provisoes
provisory1744354__provisory
provisos1336914__provis_os
provokers1894204__provokers
reprovers14217774reprov__ers
revisers113511934___revisers
upraisers11174424_upr_aisers
uprisers10206774_upr__isers

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 Filter1786911488190.436409841.7
2DLD Change Limit148819878.42317668.2
3Display Results87870.0461891.3
 (SQL Overall)178691878.90520066.4
 
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.