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

112 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
microbes143940(None) 
microbe1338661microbe_
microbus1456031microbus
disrobes1139742disrobes
microbar1445892microbar
microbars1546872microbars
microbeam1745212microbeam
microbeams1844872microbeams
microbic1647212microbic
microbrew1844342microbrew
microbrews1953902microbrews
microbuses1646202microbuses
microhms1765602microhms
microns113814782micro_ns
micros104115362micro__s
mucrones1237602mucrones
aerobes9311493_aerobes
amitroles1144723amitroles
ascribes1246193ascribes
bicornes12307253bicornes
bicrons113410473bicro_ns
cicerones1347073cicerones
cicorees1246413cicorees
crones84729243__crones
crores86121163__crores
crozes174417663__crozes
disrobe1038993disrobe_
disrobed1238093disrobed
disrober1147603disrober
disrobers1246363disrobers
enrobes92211113_enrobes
fibroses1345973fibroses
ficoes114613463fic_o_es
hidroses1237903hidroses
icones84616383_ic_ones
improves1536123improves
irones64724013_i_rones
macrames1438953macrames
macrons113514893macro_ns
macros104017013macro__s
madrones112912283madrones
manropes1237913manropes
micawber1741813micawber
micawbers1842063micawbers
micelles1288833micelles
miches134320733mic__hes
mickles153415003mic_kles
micrifies16118673micrifies
micro94715993micro___
microbial1547143microbial
microbian1576553microbian
microburst1674643microburst
microbusses1754103microbusses
microcap1645583microcap
microcodes1747373microcodes
microcosm1745783microcosm
microcytes1948423microcytes
microdot1348133microdot
microdots1446883microdots
microhm1646123micro_hm
microluces1646323microluces
microlux1943643microlux
microluxes2145013microluxes
micromere1547873micromere
micromeres1648483micromeres
micromho1744613micromho
micromhos1845513micromhos
micromoles1648423micromoles
micron103714283micro__n
micronizes2348993micronizes
micropores16610173micropores
microprobes1956513microprobes
micropyles1946963micropyles
microseism1654563microseism
microsomes1649153microsomes
microtomes1649053microtomes
microtones1449803microtones
microwaves2045363microwaves
midribs1235493midrib_s
midsoles1137763midsoles
migrates111112843migrates
mihrabs1444203mihrab_s
mikrons13428413mikro_ns
mioses84318853mi__oses
mirages102213533mi_rages
mires75640883mi_r__es
mirexes1636993mi_rexes
mirrored1145773mirrored
mirrors938623mirro_rs
miscodes13310423miscodes
misdoes10312493misdo_es
mismoves1537293mismoves
misrates101318233misrates
misroutes1148313misroutes
misrules1039383misrules
misyokes1735513misyokes
mitoses9312183mi_toses
mitres83922073mitr__es
mycoses1437723myc_oses
necroses10310563necroses
omicrons1275193omicro_ns
picrates122013203picrates
picrites121811083picrites
probes104119453__probes
reprobes121910293reprobes
robes75133303___robes
saprobes1237033saprobes
scribes113713203_scribes
strobes93813263_strobes
sucroses1039933sucroses
unrobes9269733_unrobes
viroses10310533vi_roses

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621127.23320207.7
3Display Results1121120.0333393.9
 (SQL Overall)1786911127.42224075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.