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

106 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
microliters154580(None) 
microliter1447421microliter_
microliths1745692microlit_hs
micrometers1749072micrometers
hectoliters1652133hectoliters
kiloliters1442933ki_loliters
microclines1746303microcline_s
microcytes1948423microcyte_s
microfilmers2152983microfilmers
microlith1646923microlit__h
microlithic2054023microlithic
microluces1646323microluce_s
microluxes2145013microluxe_s
micrometer16410143micrometer_
micronizes2349003micronize_s
micropipets1954683micropipets
milliliters1353043milliliters
niccolites1444133niccolite_s
acroliths1445114_acrolit_hs
aerolites9312584_aerolite_s
airliners945984ai_r_liners
colters93522444__c_ol_ters
coprolites1448224coprolite_s
crofters13358904__cro_fters
crosiers103312064__crosi_ers
croziers19287004__crozi_ers
cryolites1446964__cryolite_s
decaliters1345214dec_aliters
deciliters1345174dec_iliters
dichroites1645144dichro_ite_s
hectoliter1563254hectoliter_
ichnolites1544044_ichnolite_s
idolaters1045714_i_dolaters
idolisers1043704_i_dolisers
idolizers1944144_i_dolizers
improvisers1892774improvisers
iolites73819484_i__olite_s
kiloliter1344014ki_loliter_
kilolitres1442724ki_lolitres
macrocytes1945864macrocyte_s
marlites103415264m_ar_lite_s
micrifies16118674micrifi_e_s
microampere1953484microampere
microamperes2053204microamperes
microbars1546884micro__bars
microbes1439404micro__be_s
microbrewers2162764microbrewers
microbrews1953904micro_brews
microbuses1646204microbuse_s
microclimates2173054microclimate_s
microcline1647064microcline__
microcodes1747374microcode_s
microcyte1847984microcyte__
microdots1446884microdot__s
microfiches2354534microfiches
microfilmer2053574microfilmer_
microfilms19135044microfi_lms
microloans1446014microl_oans
micromere1547874micro__mere
micromeres1648484micro__meres
microminis1646674micromi_nis
micromoles1648424micromole_s
micronize2248904micronize__
micronized2447014micronize_d
micropipet1857804micropipe_t
micropores16610184micropore_s
micropyles1946964micropyle_s
microreaders1753244microreaders
microsomes1649154microsome_s
microsphere2055104microsphere
microspheres2154924microspheres
microspores1747414microspores
microstates1547444microstate_s
microtomes1649054microtome_s
microtones1449804microtone_s
microvillus1853214microvillus
microwatts1755044microwat_ts
microwaves2045364microwave_s
midlifers15254934mi__dlifers
milliers102611904mi__lli_ers
milliliter1243624milliliter_
milliners11289954mi__lliners
milters93619094mi___l_ters
mineralizers2353384mineralizers
mirlitons1144114mi_r_litons
misalters1136914mi_sal_ters
mislikers15317064mi__slikers
misregisters1551774misregisters
misrelates1247624misrelate_s
misrelies1149724misreli_e_s
misroutes1148314misro_ute_s
molters93816974m___ol_ters
moralizers2145844m_oralizers
natrolites1047414natrolite_s
niccolite1354414niccolite__
picholines1746304picholine_s
picolines1339624pic_oline_s
picometers1648284pic_ometers
picrites121811084picr__ite_s
pisolites1149384pi_solite_s
pistoliers1244584pistoli_ers
profiters14228314__profiters
recruiters1243714recr_uiters
saprolites1247054saprolite_s
siderolites1253404siderolite_s
violaters1245964vi__olaters

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.420425454.8
2DLD Change Limit1488191069.12616307.1
3Display Results1061060.0631682.5
 (SQL Overall)1786911069.60918596.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.