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

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

105 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
miched14391339(None) 
miche126219241miche_
miches134320731miches
niched125514061niched
ached119227832_ached
arched125717322arched
bached145519892bached
birched15349912birched
bitched153212922bitched
cached145419202cached
cinched153910862cinched
cliched153711022cliched
diced95824682dic_ed
dicked144920862dicked
dished114318712dished
ditched143711902ditched
eched116919222_eched
etched123613702etched
fiche134616742fiche_
fiches145219532fiches
filched16307422filched
fished134316312fished
hitched163312252hitched
iced78721892_ic_ed
inched124514482inched
itched123812022itched
kicked124415942kicked
kithed144613012kithed
leched123716002leched
lichee114017972lichee
lichen114012742lichen
liches114724292liches
lichted13268802lichted
licked134621562licked
maced108528692mac_ed
mache125925302mache_
maches134827232maches
macled116718112macled
marched153813402marched
mashed125325042mashed
matched153513962matched
meshed124415932meshed
mice87442232mic_e_
mickey174211852mickey
miffed15398712miffed
miked125020452mi_ked
milded104416152milded
milked134612572milked
milled94326172milled
milted93919942milted
mimed105622732mi_med
minced114114912minced
minded103817832minded
mined85333352mi_ned
minted94220582minted
mired85729222mi_red
miscued1239292miscued
misfed124113022misfed
misled94719312misled
missed94423602missed
misted93625822misted
mither114218562mither
mitred94414342mitred
mixed155717252mi_xed
mocked154716612mocked
mooched153910532mooched
moshed124517492moshed
mouched153612592mouched
muches134718992muches
mucked153816092mucked
mulched15307762mulched
munched153411072munched
mushed124420842mushed
niche105016792niche_
niches114419142niches
nicked135019682nicked
nighed113811292nighed
ouched124316932ouched
peched144915342peched
picked154421312picked
pinched153812452pinched
pished124817062pished
pitched153512922pitched
pithed124615612pithed
riced85825542ric_ed
richen113812512richen
richer114015042richer
riches115022082riches
ricked136523622ricked
ruched124314632ruched
sicced11489652sicced
sicked134524402sicked
sighed113712052sighed
smirched1634672smirched
teched124014432teched
ticced11438442ticced
ticked134720522ticked
tithed104115592tithed
viced115118182vic_ed
wiches144418752wiches
wicked164317412wicked
winched163110592winched
wished134417512wished
witched163012192witched
withed134416232withed

Search took 5 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 Filter178691825510.686260482.5
2DLD Change Limit825511053.58023058.9
3Display Results1051050.0303500.0
 (SQL Overall)1786911054.29641594.7
 
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.