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

88 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
nubucks154400(None) 
nubuck1434541nubuck_
bucks134824292__bucks
jumbucks2542952jumbucks
untucks1334672untucks
amucks1466003_amucks
auburns935573auburns
backs135729623__backs
becks135522013__becks
bocks134526573__bocks
bubus95115453bubu__s
buck125129903__buck_
bucko134614023__bucko
buckos143710893__buckos
bulks115920613__bulks
bunks115125083__bunks
bushbucks2242183bushbucks
busks115521373__busks
buybacks2144783buybacks
chucks174812933_chucks
clucks144512073_clucks
crucks144412583_crucks
cubics123810153cubic_s
cutbacks1845813cutbacks
debunks1433763debunks
ducks124823213__ducks
eunuchs1272683eunuchs
fucks144419253__fucks
gucks123917303__gucks
hucks144322173__hucks
jumbuck2443273jumbuck_
kebbucks1742353kebbucks
lucks115723563__lucks
mucks134622643__mucks
musicks15297053musicks
nebulas957583nebulas
necks115119333n__ecks
neuks96510863n_eu_ks
niblicks1643763niblicks
nicks114920493n__icks
nocks115121013n__ocks
nuances938523nuances
nubbins11268023nubbins
nubbles113412433nubbles
nubias8310083nub_ias
nubs65927143nub___s
nudnicks1542403nudnicks
nudniks1262333nudniks
numchucks2251383numchucks
nutpicks1643423nutpicks
outbacks1638983outbacks
outbulks1444763outbulks
plucks14379733_plucks
pucks134322103__pucks
quacks214710103qu_acks
quicks21389303qu_icks
rebecks15288013rebecks
roebucks1643743roebucks
rubaces1139303rubaces
rubus76415053rubu__s
rucks114422053__rucks
runbacks1655903runbacks
sawbucks1943413sawbucks
shmucks1833943shmucks
shucks154010413_shucks
subduces1397263subduces
subducts13106093subducts
suburbs1136503suburbs
sucks114523073__sucks
trucks124711973_trucks
tubules9310233tubules
tucks114721123__tucks
tussucks1442433tussucks
unblocks1644523unblocks
unbuckle1643863unbuckle
unbuckles1743193unbuckles
unbulky1642853unbulky
uncocks1537233uncocks
undocks1436163undocks
unhusks1443263unhusks
unlocks1337063unlocks
unlucky1643223unlucky
unpacks1576093unpacks
unpicks1545183unpicks
untacks1357503untacks
untuck1236403untuck_
yucks144717193__yucks
zebecks24274193zebecks

Search took 9 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.1401276364.3
2DLD Change Limit134027887.78317220.5
3Display Results88880.0302933.3
 (SQL Overall)178691887.95322468.4
 
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.