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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
monickers174508(None) 
monicker1635731monicker_
monikers1437411moni_kers
donnickers1782612donnickers
knickers13306722_knickers
mimickers1943112mimickers
mockers153812942mo__ckers
moniker1338672moni_ker_
nickers134415092__nickers
snickers143010962_snickers
bickers154316553__bickers
bonkers134015303bon__kers
clickers163910203_clickers
cockers153618333co__ckers
conifers133611703coni_fers
conkers133721043con__kers
convokers18246103convokers
detickers1634423detickers
dickers144117663__dickers
dockers143715003do__ckers
dominickers2051953dominickers
donnicker1643053donnicker_
donnikers1443443donnikers
flickers17338883_flickers
fossickers1942563fossickers
frolickers1942033frolickers
hockers163915913ho__ckers
honkers143315233hon__kers
ickers123914183___ickers
ionizers17257713ioni_zers
kickers124013293__kickers
knackers13286843_knackers
knockers13285733_knockers
lickers134118253__lickers
lockers133516923lo__ckers
maffickers2441963maffickers
manicures1346263manicures
menacers12279313menac_ers
mickeys18447943m__ickeys
milkers134411613m__ilkers
mimicker1843313mimicker_
mincers113714853min_c_ers
minibikers1842393minibikers
minicars12118523minic_ars
ministers1139623ministers
minivers1337483mini_vers
mocker143315443mo__cker_
mockery18376913mo__ckery
modifiers1584483modifiers
moilers93615203mo_i_lers
moneyers1337423mon_eyers
mongers104217273mon__gers
monies83233163moni__e_s
monishes13311483monishe_s
monitors10310823moni_tors
monkery16317453mon__kery
monkeys16407423mon__keys
monocles12310673monocle_s
monomers12311033mon_omers
monsters103314553mon_sters
moochers15369123mo_ochers
motioners1146573motioners
muckers153612803m__uckers
munchers15318773mun_chers
neckers134210463__neckers
nickels13338653__nickels
nicker123818703__nicker_
noticers1035693notic_ers
ockers123813903_o__ckers
pickers153718093__pickers
picnickers2042123picnickers
policers12259993polic_ers
prickers163710673_prickers
rockers133916553ro__ckers
shickers173012823_shickers
slickers143112553_slickers
snackers143010223_snackers
snicker133012673_snicker_
snickery17295543_snickery
stickers142913033_stickers
tickers133617723__tickers
trickers143812813_trickers
voicers12348993vo_ic_ers
whickers20297983_whickers
wickers164114703__wickers
yonkers14379823yon__kers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641867.32620289.5
3Display Results86860.0461869.6
 (SQL Overall)178691867.79522923.8
 
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.