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

61 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
microdissection2271411microdissection_
microinjection2762554micro_injection_
microinjections2862424micro_injections
microinjecting2861945micro_injecti_ng
microprojection3072655microprojection_
codirection1644706__c_odi_rection_
codirections1744656__c_odi_rections
dissection13158606_____dissection_
dissections14198246_____dissections
micropulsation2082516micropuls_ation_
micropulsations21102246micropuls_ations
microsecond1853996micro___sec__ond
midsection1544416mi___d__section_
midsections1644386mi___d__sections
misdirection1754136mi__sdi_rection_
misdirections1854196mi__sdi_rections
bidirectional18152477bi___di_rectional
circumspection2172557ci_rcumspection_
circumspections2272257ci_rcumspections
codirecting1743637__c_odi_recti_ng
dissecting14139477_____dissecti_ng
dissention11188057_____dissention_
dissentions12168027_____dissentions
improvisation2052997improvi_s_ation_
improvisational2261657improvi_s_ational
improvisations2152537improvi_s_ations
indirection1456357_i__ndi_rection_
indirections1556157_i__ndi_rections
introspection1764627intro__spection_
introspectional1972627intro__spectional
introspections1864057intro__spections
microcassette1962267microcasse_t__te
microcassettes2071937microcasse_t_tes
microelectrode2172447micro__electrode
microelectronic20112537micro__electronic
microevolution2182647micro_evolution_
microevolutions2282337micro_evolutions
microinject2453567micro_inject____
microinjected2762087micro_inject__ed
microinjects2562697micro_inject___s
microprojector29112347microproject_o_r
microprojectors3082167microproject_ors
microseconds1953477micro___sec__onds
misconnection1954127misco__nnection_
misconnections2063817misco__nnections
misdirecting1853227mi__sdi_recti_ng
misrecollection2171357misrecollection_
misregistration1871447misregistration_
predilection1754097__predi_lection_
predilections1853547__predi_lections
redirection1446037___redi_rection_
redirections1546147___redi_rections
retrodiction1555657retrodi___ction_
retrodictions1655537retrodi___ctions
retrospection1784317retro__spection_
retrospections1894167retro__spections
trisection1245987__tr__i_section_
trisections1345637__tr__i_sections
vivisection1952697vi___vi_section_
vivisectional2162087vi___vi_sectional
vivisections2052707vi___vi_sections

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 Filter178691950240.1261418182.5
2DLD Change Limit95024619.45310052.3
3Display Results61610.0461326.1
 (SQL Overall)178691619.62518565.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.