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

182 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
nobbily143669(None) 
snobbily1544231snobbily
knobbly1842872knobb_ly
nobbier11309162nobbier
nobble103814312nobb_le
nobby125513462nobb__y
nobly105314402no_b_ly
noily86120992no__ily
noisily1038402noisily
nonoily1049542nonoily
nosily93712682no_sily
nubbly13369672nubb_ly
wobbly16347092wobb_ly
bobbery13438353bobbery
bobbies103714563bobbies
bobbin93410733bobbi_n
bobbing113113193bobbing
bobbins103410343bobbins
bobble94115143bobb_le
bobby114814663bobb__y
bodily12310993bo_dily
bonnily1236873bonnily
boozily2135623boozily
bossily1237563bossily
boxily1877843bo_xily
bubbly124110353bubb_ly
chubbily2042913chubbily
cobbier133410163cobbier
cobble123615263cobb_le
cobby145516413cobb__y
cockily1838493cockily
cornily12410853cornily
cosily113613853co_sily
cozily20349703co_zily
crabbily1744343crabbily
dobbies124113063dobbies
dobbin11339523dobbi_n
dobbins12379533dobbins
dobby136013633dobb__y
doily95321033do__ily
doomily1336133doomily
dopily123510463do_pily
dottily1147283dottily
doubly12328963doub_ly
dowdily1534953dowdily
dozily19329103do_zily
flabbily1843353flabbily
foamily1546543foamily
fobbing153410273fobbing
foggily1535053foggily
foxily1947253fo_xily
gobbing132910703gobbing
gobble113512983gobb_le
godlily1235343godlily
goofily14105353goofily
gorily10612503go_rily
goutily1137933goutily
grubbily1642973grubbily
hoarily1338973hoarily
hobbies143813343hobbies
hobbing152811123hobbing
hobbit132810533hobbi_t
hobbits14317553hobbits
hobble133913433hobb_le
hobby155913733hobb__y
hokily16409093ho_kily
holily123612953ho_lily
homily144712333ho_mily
hornily1338283hornily
horsily1338843horsily
hubbly16478413hubb_ly
jobbery21366013jobbery
jobbing19279013jobbing
jokily20306533jo_kily
jollily1745773jollily
joltily1746323joltily
knobbier1652703knobbier
knobby1732713knobb__y
knottily1543153knottily
lobbied12337173lobbied
lobbies113612463lobbies
lobbing123110913lobbing
lobby125113923lobb__y
loftily1336353loftily
logily1039833lo_gily
loonily1037073loonily
loopily1236803loopily
lousily1038333lousily
lowlily1335353lowlily
mobbing14299703mobbing
mobbish1635923mobbish
mobbishly2142693mobbishly
mobbism1535053mobbism
mobile103613543mo_bile
moodily1358203moodily
moonily1248943moonily
morbidly1643833morbidly
mousily1239393mousily
nabbing12299963nabbing
nastily103011033nastily
nattily103610323nattily
nebbish1444253nebbish
nebbishy1841303nebbishy
nebuly1135793n_ebuly
needily1166323needily
nervily1336863nervily
nibbing12339553nibbing
nibble103713283nibb_le
niftily1335753niftily
nimbly13388773nimb_ly
nippily1444713nippily
nobbiest12117773nobbiest
nobbled123511283nobbled
nobbler113211183nobbler
nobbles114014523nobbles
nobbling13228273nobbling
nobility1348983nobility
noble74420993no_b_le
nobody1235743no_body
nodally1137913nodally
noil46133243no__il_
noils55024333no__ils
noisy86813363no__isy
nombril1145103nombril_
nombrils1244513nombrils
nonbody1344823nonbody
notably12199993notably
notedly1136883notedly
notify1236943no_tify
novelly1346513novelly
nubbier11308133nubbier
nubbin10308293nubbi_n
nubbins11268023nubbins
nubble103813713nubb_le
nubby125011033nubb__y
nubile83212713n_ubile
numbly134410663numb_ly
nuttily10308633nuttily
oilily93111723_oilily
oily77932253_o__ily
oozily18328073_oozily
pebbly1545083pebb_ly
pockily1846233pockily
podgily1435213podgily
pokily15309063po_kily
rabbity14266303rabbity
robbery14348283robbery
robbin103611183robbi_n
robbing123313213robbing
robbins112811063robbins
roily86121113ro__ily
roomily1237283roomily
ropily113312443ro_pily
rosily93914713ro_sily
roupily1246653roupily
rowdily1436083rowdily
rubbly133710613rubb_ly
scabbily1763943scabbily
shabbily1873903shabbily
snobbery15514293snobbery
snobbier1234633snobbier
snobbish1544213snobbish
snobbishly2051763snobbishly
snobbism1443393snobbism
snobby1334403snobb__y
snoopily1345553snoopily
snootily1136243snootily
snottily1145543snottily
snowily1336883sno_wily
soapily1237963soapily
sobbing127612883sobbing
sobbingly1744343sobbingly
soberly1236943soberly
soggily1235953soggily
sootily101810513sootily
sorrily1039823sorrily
stubbily1564243stubbily
wabbly16348363wabb_ly
wobble133212313wobb_le
woozily2234383woozily
wordily1437853wordily
zombify2642253zombify

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.1561145455.1
2DLD Change Limit1340271828.00016753.4
3Display Results1821820.0632888.9
 (SQL Overall)1786911828.21921741.2
 
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.