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

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

110 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
microbe133866(None) 
microbes1439401microbes
disrobe1038992disrobe
micro94715992micro__
microbar1445892microbar
microbeam1745212microbeam
microbic1647212microbic
microbrew1844342microbrew
microbus1456032microbus
microhm1646122microhm
micron103714282micro_n
microns113814782microns
micros104115362micro_s
aerobe8412403_aerobe
amitrole1045173amitrole
ascribe1147743ascribe
bichrome1745653bichrome
bicorne11297553bicorne
bicron103710773bicro_n
bicrons113410473bicrons
cicerone1247523cicerone
cicoree1149843cicoree
cirrose937473cirrose
crone75231333__crone
crore74922873__crore
croze164719453__croze
disrobed1238093disrobed
disrober1147623disrober
disrobes1139743disrobes
enrobe86610793_enrobe
improve1435963improve
irone55126363_i_rone
macrame1338713macrame
macro94718173macro__
macron103615673macro_n
macrons113514893macrons
macros104017013macro_s
madrone102812663madrone
manrope1138033manrope
micawber1741813micawber
mice87442243mic___e
micelle1178343micelle
miche126219243mic__he
mickle143715133mic_kle
micra96214973micr__a
micrify1744693micrify
microbars1546883microbars
microbeams1844873microbeams
microbial1547153microbial
microbian1576563microbian
microbrews1953903microbrews
microbuses1646203microbuses
microcap1645583microcap
microcode1647013microcode
microcyte1847983microcyte
microdot1348133microdot
microhms1765613microhms
microlux1943643microlux
micromere1547873micromere
micromho1744613micromho
micromole1547833micromole
micronize2248903micronize
micropore1579313micropore
microprobe1855923microprobe
micropyle1846273micropyle
microsome1549103microsome
microtome1548683microtome
microtone1349673microtone
microwave1945033microwave
midrib1138243midrib_
midribs1235513midribs
midsole1037813midsole
migrate101314173migrate
mihrab1335523mihrab_
mihrabs1444203mihrabs
mikron12318503mikro_n
mikrons13428413mikrons
mirage92313653mi_rage
mire66748243mi_r__e
mirror848003mirro_r
mirrored1145773mirrored
mirrors938623mirrors
mischose1547263mischose
miscode12310413miscode
misdone10310863misdone
misdrove1445433misdrove
mismove1437083mismove
misrate91319143misrate
misroute1049103misroute
misrule939353misrule
miswrote1346183miswrote
misyoke1635823misyoke
mitre75522423mitr__e
morose85116243m_orose
mucose10149313muc_ose
mucro94513723mucro__
mucrones1237603mucrones
necrose939733necrose
omicron1165063omicro_n
omicrons1275193omicrons
picrate112014143picrate
picrite111911313picrite
probe94320813__probe
reprobe112310133reprobe
robe65335643___robe
saprobe1137333saprobe
scribe104613533_scribe
strobe84513813_strobe
sucrose939313sucrose
unrobe82611673_unrobe

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271106.64020184.8
3Display Results1101100.0333333.3
 (SQL Overall)1786911107.07925242.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.