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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
microcircuitry22163274(None) 
microcircuit1773122microcircuit__
microcircuits1872452microcircuit_s
circuitry1652805_____circuitry
microgravity2382715micro_gravit_y
microporosity2263285microporosit_y
circuity1544946_____circuit_y
iconicity1645626_ic_oni_c_it_y
microbrewery2461936micro_br_ewery
micrococci1454496microc_occi___
micrococcus1593886micrococcu___s
microcomputer23152776microcompu_ter
microcomputers24202186microcomputers
microcrystal2162596microc_r_ystal
microculture1864406micro___culture
microcurie1656356microcur__i__e
microcuries1756706microcur__i_es
microstructure20163486microstructure
microsurgery2062556microsur__gery
microtonality2063136microtonalit_y
microvascular2292146microvascular_
promiscuity2051566__promiscuit_y
chronicity2054817_chroni_c_it_y
circuit1148837_____circuit__
circuital1343847_____circuital
circuited1444567_____circuited
circuits1246017_____circuit_s
clonicity1645327__cloni_c_it_y
congruity1544397__c_ongr_uit_y
conicity15411087__c_oni_c_it_y
crocidolite1651547__crocidolit_e
crocidolites1751427__crocidolites
historicity1953297histori_c_it_y
incongruity1772317_incongr_uit_y
indocility1654497_indoci__lit_y
ionicity1348817_i__oni_c_it_y
macrocyclic1852727macroc_ycli__c
macrostructure20143137macrostructure
mediocrity1852087medioc_r__it_y
microbic1647167microbi_c_____
microbiology2263747microbi__ology
microbrewer2053107micro_br_ewer_
microbrewers2162767micro_br_ewers
microbrewing2262347micro_brewi_ng
microbrewings2361757micro_brewings
microburst1674647microbur__st__
microbursts1753797microbur__st_s
microcapsule2062577microcapsu__le
microcapsules2162457microcapsu_les
microcassette1962257microc_assette
microcassettes2071937microcassettes
microcephaly26103387microc__ephaly
microchip2045107micro___chi__p
microchips2145077micro___chi_ps
microclimate2063337microc_limat_e
microclimates2173057microc_limates
microclimatic2062277microc_limatic
microcline1647037micro___cli_ne
microclines1746277micro___clines
micrococcal1553857microc_oc__cal
microcopies19117837microc__opi_es
microcopy2085487micro___c__opy
microcosmic1854227microc_osmi__c
microcrystals2262087microc_rystals
microcultural1963627microcultu_ral
microcultures1964707microcultu_res
microcyte1847977micro___c_yt_e
microcytes1948407micro___c_ytes
microcytic1856187micro___c_ytic
microevolution2182647microevolution
microfibril2063257microfi_bri__l
microfibrillar2371147microfibrillar_
microfibrils2173037microfi_bri_ls
microfiche2254227microfi_c___he
microfiches2354517microfi_c__hes
microfilaria19143467microfilari__a
microfilariae20142757microfilari_ae
microfilarial20142667microfilari_al
microfilmer2053577microfi__lmer_
microfilmers2152987microfi__lmers
microfilming2252637microfi_lmi_ng
microgravities2262497micro_gravities
microhabitat2163027micro__habitat
microinch1844537micro_inc____h
microinches2054217micro_inc__hes
microinject2453557micro_inject__
microinjected2762077micro_injected
microinjects2562687micro_inject_s
microliter1447417micro____liter
microliters1545797microli___ters
microlith1646907micro____lit_h
microlithic2053997microli_thi__c
microliths1745677micro____liths
micromini1546567micromi__ni___
microminiature2071377microminiature
microminis1646627micromi__ni__s
micronizing2545937microni__zi_ng
microparticle2192817micropar_ticle
microphotometry2991737microphotometry
micropipet1857807micropi__pet__
micropipets1954677micropi__pet_s
micropipette2062977micropi__pette
micropipettes2182627micropi_pettes
microporosities2182787microporosities
microporous1756137microporou___s
microprism1855817micro_pr__i_sm
microprisms1955407micro_pr__isms
micropuncture2162257micropunc_ture
microreader1653907micro__reader_
microreaders1753237micro__readers
microscopy21115827micro__sc__opy
microseismicity2681107microseismicit_y
microstructural2182457microstructural
microstructures21173187microstructures
microsurgical2062467microsur_gical
microswitch23122007micro___switch
microtubular1861947micro_tubular_
microvillar1852697microvi__llar_
microvilli1753827microvi_lli___
microvillus1853217microvillu___s
minority1347907mi_no__r__it_y
miscibility2055407mi__scibilit_y
perspicuity2052147_perspi_cuit_y
propinquity2761447__propinquit_y
sacrosanctity207827sacrosanctit_y

Search took 17 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.1561145455.1
2DLD Change Limit14881912516.2369166.0
3Display Results1251250.0931344.1
 (SQL Overall)17869112516.48510839.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2023  |  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.