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

116 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
monicker163573(None) 
monickers1745081monickers
moniker1338671moni_ker
donnicker1643052donnicker
mimicker1843312mimicker
mocker143315442mo__cker
monikers1437412moni_kers
nicker123818702__nicker
snicker133012672_snicker
bicker144819173__bicker
bonier84321993boni__er
clicker154111883_clicker
cocker144320393co__cker
colickier1743513colickier
conciser12310243conciser
conifer123212643coni_fer
conker124721553con__ker
convoker17226903convoker
deticker1545283deticker
dicker134521403__dicker
docker134417653do__cker
dominicker1952213dominicker
donnickers1782613donnickers
donniker1333923donniker
finickier1842623finickier
flicker163610623_flicker
fossicker1843023fossicker
frolicker1842393frolicker
hocker155118563ho__cker
hoicked1735963ho_icked
honker134117463hon__ker
icker114018443___icker
ionizer162310123ioni_zer
kicker114116183__kicker
knacker12307913_knacker
knickers13306723_knickers
knocker12296393_knocker
licker125222043__licker
locker124019423lo__cker
mafficker2342253mafficker
magicked1842963magicked
manicure1245803manicure
menacer112610883menac_er
mickey174211853m__ickey
mickler153310233m__ickler
milker124814323m__ilker
mimicked1943253mimicked
mimickers1943113mimickers
mincer104017363min_c_er
mincier113512473min_cier
minibiker1742753minibiker
minicar11109323minic_ar
minister10410363minister
miniver1238393mini_ver
mirker123712693m__irker
mocked154716613mo__cked
mockers153812943mo__ckers
mockery18376913mo__ckery
modifier1446703modifier
moiler84017263mo_i_ler
moister94015373mo_ister
moneyer1237903mon_eyer
monger94418333mon__ger
monie75631653moni__e_
monied94319463moni__ed
monies83233163moni__es
monished1438133monished
monishes13311483monishes
monitor9310723moni_tor
monkery16317453mon__kery
monkey153710593mon__key
monocle1139663monocle_
monocled1337113monocled
monocles12310673monocles
monomer11311893mon_omer
monster93214603mon_ster
moocher143610673mo_ocher
moonier93714103mooni__er
mopier103914783mopi__er
mosaicked1842483mosaicked
motioner1037593motioner
mucker143816393m__ucker
muncher143610373mun_cher
musicked1734033musicked
necker124012793__necker
nicer74618293__nic_er
nicked135019683__nicked
nickel123811343__nickel
nickers134415093__nickers
noticer937273notic_er
ocker113915753_o__cker
panicked1785173panicked
panickier1743173panickier
picker144422173__picker
picnicker1942693picnicker
policer113112683polic_er
pricker154013413_pricker
quicker2247023_quicker
rocker124319573ro__cker
shicker163914823_shicker
sicker124023903__sicker
slicker133314533_slicker
snacker133112603_snacker
snicked143811633_snicked
snickers143010963_snickers
snickery17295543_snickery
sticker133515883_sticker
thicker163611023_thicker
ticker124321503__ticker
tonier65520713toni__er
tricker134615523_tricker
unsicker1435303unsicker
voicer113910543vo_ic_er
whicker19359773_whicker
wicker154518673__wicker
yonker134110853yon__ker

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.423422437.4
2DLD Change Limit1461621166.86021306.4
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.32924381.4
 
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.