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

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

118 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
microclines174630(None) 
microcline1647061microcline_
croceines1347733__croceines
isoclines1146223_i_soclines
microchips2145123microchi_ps
microclimates2173053microclimates
microcodes1747373microc_odes
microcopies19117853microcopies
microcuries1756723microcuries
microcytes1948423microc_ytes
microliter1447423micro_liter
microliters1545803micro_liters
microliths1745693micro_liths
microluces1646323micro_luces
microluxes2145013micro_luxes
microminis1646673micro_minis
micronizes2349003micro_nizes
microphones2048753microphones
microtones1449803micro_tones
monoclines1446813m_onoclines
picholines1746303picho_lines
picolines1339623pic_o_lines
airlines8312794ai_r__lines
cholines132214494__cho_lines
citrullines1351594citrullines
cocaines121314444__c_ocaines
croceine1248034__croceine_
croceins1238104__crocein_s
crocine11314154__croc_ine_
crocoites1347464__crocoites
dicyclies1744034dic_ycli_es
disinclines1454704disinclines
haloclines1544214_haloclines
inclines10313144_i__nclines
isocline1047294_i_socline_
isolines8312304_i_so_lines
lidocaines1352864li_docaines
ligroines1044994ligro__ines
macrocytes1945864macroc_ytes
mandolines1347104mando_lines
marlines103818714m_ar__lines
marocains1346354m_arocain_s
merocrine1346234m_erocrine_
micrifies16118674micr_ifi_es
microbalances2162534microbalances
microbes1439404micro___bes
microbuses1646204micro_buses
microbusses1754104microbusses
microchip2045174microchi__p
microclimate2063334microclimate
micrococcus1593904micrococcus
microcode1647014microc_ode_
microcosmos1974074microcosmos
microcosms1865994microc_osms
microcultures1964724microcultures
microcurie1656394microcurie_
microcyte1847984microc_yte_
microfaunas1853694microfaunas
microfiches2354534microfiches
microfilmed2153314microfilmed
microfilmer2053574microfilmer
microfilmers2152984microfilmers
microfilms19135044micro_films
microfloras1854634microfloras
microimages1854734microimages
microinch1844554micro__inch
microinches2054244microinches
microlith1646924micro_li_th
microloans1446014micro_loans
micromeres1648484micro_meres
micromini1546594micro_min_i
micromoles1648424micro_moles
micronize2248904micro_nize_
micronized2447014micro_nized
microns113814784micro___n_s
microphages2156914microphages
microphone1948334microphone_
micropipet1857804micro_pipet
micropipets1954684micro_pipets
micropores16610174micro_pores
microprisms1955414microprisms
microprobes1956514microprobes
micropyles1946964micro_pyles
microquakes28143704microquakes
microscales1756374microscales
microscopes19119094microscopes
microscopies20167244microscopies
microseisms1753904microseisms
microsomes1649154micro_somes
microspores1747414microspores
microstates1547444microstates
microtomes1649054micro_tomes
microtomies1748554microtomies
microtone1349674micro_tone_
microvillus1853214microvillus
microwaves2045364micro_waves
micrurgies1552794micrurgi_es
midlines112613334mi___dlines
migraines1286934migr__aines
millines102718064mi___llines
miracles1238334mi_racl__es
mirrorlike1651574mirrorlike_
misrelies1149724misr_eli_es
monocline1347794m_onocline_
mucrones1237604mucro___nes
niccolites1444134nicco_lites
nicotines1148354nic_o_tines
nigrosines1143834nigro_sines
picholine1646644picho_line_
picoline12310854pic_o_line_
picolins1239854pic_o_lin_s
procaines13311524__procaines
proclises1339544__proclises
prolines102619694__pro_lines
reclines103718544___reclines
silkolines1443384silko_lines
thermoclines1953304thermoclines
trotlines939104__trotlines

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 Filter1786911488190.406440125.6
2DLD Change Limit1488191188.58017344.9
3Display Results1181180.0601966.7
 (SQL Overall)1786911189.04619753.6
 
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.