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

48 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
reprovisioning206162(None) 
provisioning1883592__provisioning
previsioning1884083__previsioning
repositioning1653673rep_ositioning
reprovision1653713reprovisio__n_
reprovisioned1961613reprovision_ed
reprovisions1753773reprovisio__ns
envisioning1552844_e__nvisioning
decisioning1543935de___cisioning
empoisoning1652135_empo_is_oning
imprisoning1652695impr__is_oning
improvising1943845improvis___ing
pavilioning1752375__p_avilioning
poisoning1245905__p_o_is_oning
positioning1454555__p_ositioning
preportioning1853605prep_o_rtioning
prerevisionist19102525pre_revisionist
previsiting1745545__previsi_ting
prisoning1237645__pr__is_oning
processioning1853745__processioning
propositioning1972795prop_ositioning
provision1447635__provisio__n_
provisional1655465__provision_al
provisionals1753765__provisionals
provisionary2073245__provisionary
provisioned1753975__provision_ed
provisioner1653795__provision_er
provisioners1752815__provisioners
provisions1547215__provisio__ns
reapportioning1961625reappo_rtioning
recommissioning2271665recommissioning
reconditioning1872515reconditioning
reconsigning1653445re_co_nsigning
remoistening1552745re_mo_istening
replevining1743155replev__i_ning
repolishing1744585rep_olis__hing
repositing13310495rep_o__si_ting
repressionist1555325repr_essionist
reprising12312555repr__is___ing
reprivatizing2873325reprivati_zing
reprocessing1754695reproces__sing
reproving1538415reprov_____ing
requisitioning2461465requisitioning
revisionism16144815re___visionism
revisionist14146525re___visionist
revisiting1446955re___visi_ting
vermilioning1861495ve_r_milioning
visioning1347065_____visioning

Search took 8 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.360496363.9
2DLD Change Limit95024487.15613278.9
3Display Results48480.0301600.0
 (SQL Overall)178691487.54623680.2
 
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.