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

131 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
microscopes1911909(None) 
microscope18138571microscope_
microscopies20167241microscopies
dichroscopes2254112dichroscopes
microcodes1747372micro_codes
microcopies19117852micro_copies
microscales1756372microscales
microscopic1856382microscopic
microscopist2055642microscopist
microscopy21115842microscop_y
microsomes1649152micros_omes
microspores1747412microspores
aeroscopes1448013_aeroscopes
baroscopes1646753_baroscopes
bioscopes1546553bi__oscopes
cryoscopes1995253__cryoscopes
dichroscope2154033dichroscope_
gyroscopes1845073_gyroscopes
horoscopes1747643_horoscopes
iconoscopes1753733_iconoscopes
macroscales1753853macroscales
macroscopic1855033macroscopic
microcode1647013micro_code_
microcopy2085493micro_cop_y
microcosms1865993micro_cosms
microcytes1948423micro_cytes
micromoles1648423micro_moles
microphones2048763microphones
micropores16610183micro_pores
microprobes1956513microprobes
microscale1646393microscale_
microscopists2164063microscopists
microseconds1953483microseconds
microsome1549103micros_ome_
microspore1646863microspore_
microstates1547443microstates
microtomes1649053micro_tomes
microtones1449803micro_tones
myoscopes1845043m__yoscopes
acrosomes1347844_acros_omes
aeroscope1347684_aeroscope_
airscapes1345024ai_r_scapes
arthroscopes19125314arthroscopes
baroscope1546574_baroscope_
bioscope1446484bi__oscope_
bioscopies1645384bi__oscopies
borescopes1645174_borescopes
cryoscope1895144__cryoscope_
cryoscopies2054174__cryoscopies
cystoscopes2053924cystoscopes
electroscopes19155704electroscopes
endoscopes1545814_endoscopes
fetoscopes1745394_fetoscopes
fiberscopes2052494fiberscopes
fluoroscopes19244404fluoroscopes
gastroscopes17104684gastroscopes
gyroscope1755014_gyroscope_
hagioscopes1953894hagioscopes
hodoscopes1855784_hodoscopes
horoscope1647274_horoscope_
horoscopies1856114_horoscopies
iconoscope1653534_iconoscope_
kinescopes1864214ki_nescopes
kinetoscopes2062494kinetoscopes
laparoscopes1873414laparoscopes
macrocosms1853634macro_cosms
macrocytes1945864macro_cytes
macromoles1645374macro_moles
macroscale1654114macroscale_
microbes1439404micr___obes
microbuses1646204micro_buses
microbusses1754104microbusses
microcap1645584micro_cap__
microchips2145124micro_chips
microclines1746304microclines
micrococci1454524micro_cocci
micrococcus1593904micro_coccus
microcosm1745784micro_co_sm
microcosmos1974074micro_cosmos
microcosmoses2162774microcosmoses
microcuries1756724microcuries
microcyte1847984micro_cyte_
microdots1446884micro_do_ts
microfiches2354534microfiches
microfloras1854634microfloras
microforms1946394micro_forms
micrographs2147784micrographs
microgrooves2082994microgrooves
microimages1854734microimages
microinches2054244microinches
microloans1446014micro_loans
microluces1646324micro_luces
microluxes2145014micro_luxes
micromeres1648484micro_meres
micromhos1845514micromho__s
micromole1547834micro_mole_
micronizes2349004micro_nizes
microphages2156914microphages
microphone1948334microphone_
micropipet1857804micro_pipet
micropipets1954684micro_pipets
micropore1579304micro_pore_
microprobe1855924microprobe_
micropyles1946964micro_pyles
microquakes28143704microquakes
microscopical2063354microscopical
microsecond1853994microseco_nd
microseisms1753904microseisms
microsomal1655924micros_omal
microspheres2154924microspheres
microsporous1853614microsporous
microstate1448014microstate_
microtome1548684micro_tome_
microtomies1748554microtomies
microtone1349674micro_tone_
microvolts1765494micro_volts
microwaves2045364micro_waves
miscodes13310424mi___scodes
miscopies1549614mi___scopies
myoscope1744994m__yoscope_
nephoscopes2054294nephoscopes
nightscopes1952644nightscopes
otoscopes1346514__otoscopes
periscopes1646354_periscopes
roscoes9310924___rosco_es
spectroscopes2163394spectroscopes
statoscopes1554824statoscopes
stereoscopes1654294stereoscopes
synchroscopes2563434synchroscopes
thermoscopes2164944thermoscopes
uroscopies1455384__uroscopies

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.440406115.9
2DLD Change Limit1488191318.67017164.8
3Display Results1311310.0632079.4
 (SQL Overall)1786911319.17319480.1
 
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.