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

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
microprojectors3082161microprojectors_
microprojector29112342microprojector__
microprocessors2371744microprocessors_
microprojection3072654microproject_ion
microprocessor2272015microprocessor__
microinjections2862426micro_injections_
microinjects2562696micro_inject__s_
microprobes1956516microprobe____s_
projectors21187176_____projectors_
chiropractors2291827chiropr__actors_
coprocessors1852537__c_oprocessors_
coproprietors1962437copropr_ie_tors_
correctors1447497__c_o_r_rectors_
interjectors2155047_i_nter_jectors_
megaprojects266957m_egaproject__s_
microbrewers2162767microbr__e_wers_
microcomputers24202187micro_computers_
microelectrode2172447micro__electrode
microinject2453567micro_inject____
microinjected2762087micro_inject__ed
microinjecting2861947micro_inject_ing
microinjection2762557micro_inject_ion
micrometers1749077mic___rome_ters_
microphones2048757microphone____s_
microphonics2355377microphonic___s_
micropipets1954687microp_ipe_t__s_
micropipettes2182637microp_ipe_ttes_
microplanktons24101917microp_lanktons_
micropores16610177microp_ore____s_
microporosities2182787microporosities_
microporous1756147microp_o___rous_
microprobe1855927microprobe______
microprogram2163557micropro____gram
microprograms2263087micropro__grams_
micropuncture2162257microp__unctur_e
micropunctures2272247microp__unctures
microreaders1753247micro_r__eaders_
projector20186687_____projector__
propraetors1554187__propr_ae_tors_
propretors1445797__propr__e_tors_
proprietors1554387__propr_ie_tors_
proprioceptors1971837__proprioceptors_
prosectors14199127_____prosectors_
protectors142010147_____protectors_

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.1061685764.2
2DLD Change Limit95024448.33011407.4
3Display Results44440.0301466.7
 (SQL Overall)178691448.46621106.9
 
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.