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

239 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
notify123694(None) 
citify1437442citify
codify1537162codify
fortify1636522fortify
modify1537172modify
mortify1536222mortify
motif10519682motif_
motifs1139672motifs
nazify2134232nazify
nidify1336762nidify
nitrify1335792nitrify
noily86120992no_ily
noisy86813362no_isy
nosily93712682nosily
notary92310712notary
notice8313442notice
noting74120152noting
notion64516582notion
ratify122610042ratify
renotify1454832renotify
acetify1545003acetify
aerify122810113aerify
artily92814713artily
basify1437513basify
beatify1536593beatify
bodily12310993bodily
botany1139263botany
botchy16537823botchy
botfly1436093botfly
bothy136713963bot_hy
boxily1877843boxily
brutify1543883brutify
certify1546243certify
coalify1536683coalify
coif96337913co_if_
coifs105718703co_ifs
comfy153710213co_mfy
comity13312713comity
cornify1536253cornify
cosily113613853cosily
coting94629253coting
cozily20349703cozily
deify124112763_deify
doily95321033do_ily
dopily123510463dopily
dotier73917033dotier
doting84821913doting
dottily1147283dottily
dotty94516103dot_ty
doty86128223dot__y
dozily19329103dozily
edify12308563_edify
entity9312053entity
foxily1947253foxily
gasify1336333gasify
glorify1444583glorify
gonif94320923gonif_
goniff13408893goniff
gonifs104310133gonifs
goofy124915623go_ofy
gorily10612503gorily
goutily1137933goutily
gratify1436113gratify
hokily16409093hokily
holily123612953holily
homily144712333homily
hominy144511483hominy
horrify1635023horrify
hotly115815483hot_ly
ignify1334513ignify
jokily20306533jokily
jollify2044263jollify
joltily1746323joltily
jotty155012603jot_ty
justify2034663justify
knottily1543153knottily
knotty13315223knot_ty
lithify1644763lithify
loftily1336353loftily
logily1039833logily
loti46431843loti__
lotic76420673loti_c
lotion65716523lotion
metrify1535623metrify
minify1439253minify
mollify1555503mollify
motey105922953mot_ey
mothy136214553mot_hy
motific1446323motific
motile83818343motile
motion85217553motion
motive113112143motive
motley1139383motley
mutiny113612683mutiny
mystify1843563mystify
naif76839023n_aif_
naifs87617423n_aifs
nastily103011033nastily
nation64322803nation
native9613013native
nattily103610323nattily
natty85719143nat_ty
neif75429493n_eif_
neifs85613043n_eifs
neoteny1045023neoteny
nettly9459453nettly
netty85816763net_ty
niftily1335753niftily
nifty115211633n__ifty
nigrify1444133nigrify
nitery94412173nitery
nitid61817833niti_d
nitty85418313nit_ty
nixy145714513n__ixy
nobbily1436693nobbily
nobby125513463no_bby
nobly105314403no_bly
nobody1235743nobody
noddy105411203no_ddy
nodi56626743nodi__
noetic8514043noeti_c
noil46133243no_i_l
noils55024333no_ils
noir46722433no_i_r
noirs55615463no_irs
noise55723733no_ise
noisily1038403noisily
nomina83113683nomina
nomism103010953nomism
nongay10169153nongay
nonlife1038553nonlife
nonoily1049543nonoily
nooky124814813no_oky
nori47133143nori__
noria55722183nori_a
norias65518203norias
noris54928273nori_s
norite63221133norite
nosey85619883no_sey
nosier63716323nosier
nosing73419843nosing
nosy76322893no__sy
not39474663not___
nota46830773not__a
notably12199993notably
notal55221353not_al
notate63217863notate
notch105613323not_ch
note46239963not__e
noted65123843not_ed
notedly1136883notedly
noter55025643not_er
noters64021003noters
notes55034583not_es
nother93815963nother
nothing113511903nothing
noticed1037863noticed
noticer937273noticer
notices9312283notices
notified1238363notified
notifier1137423notifier
notifies11310423notifies
notifying1645623notifying
notions74014483notions
notum7611693not_um
novice1138433novice
noway111112843no_way
nowise9511073nowise
nudity1037993nudity
nullify1334713nullify
nutsy85711503nut_sy
nuttily10308633nuttily
nutty84816873nut_ty
oily77932253_o_ily
ontic74418573onti_c
ootid61416703ooti_d
ootids71110353ootids
oozily18328073oozily
ossify1244973ossify
otic66624823_oti_c
pacify1667473pacify
petrify1536573petrify
pokily15309063pokily
policy133211513policy
polity113015863polity
pontiff1547903pontiff
poofy136213273po_ofy
potboy1397813potboy
potion84519573potion
potsy105815613pot_sy
potty105621003pot_ty
pouffy17395883pouffy
prenotify1744283prenotify
purify14399153purify
ramify14268753ramify
rarify123210063rarify
rectify1536453rectify
reify114814973_reify
roily86121113ro_ily
ropily113312443ropily
rosily93914713rosily
rosiny94414533rosiny
rotary92411303rotary
roti46332933roti__
rotifer1036993rotifer
rotis56327063roti_s
salify12311373salify
sanctify1644493sanctify
satiny93817983satiny
satisfy1344183satisfy
scorify1535203scorify
snootily1136253snootily
snottily1145553snottily
snotty9489203snot_ty
snowily1336883snowily
sootily101810523sootily
stiff114219243_stiff
stimy105114743_stimy
testify13246943testify
tidy86822413__tidy
tiff104727723__tiff
tiny76134633__tiny
tivy1014516863__tivy
toffy145310283to_ffy
torrify1335013torrify
toting74123793toting
typify1734523typify
uglify1333913uglify
unify113611113_unify
untidy1059153untidy
verify153110163verify
vilify1536773vilify
vinify1536923vinify
vitrify1645003vitrify
vivify1834703vivify
votary12248333votary
voting103916033voting
votive12348933votive
zombify2642253zombify

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162395.69019809.5
3Display Results2392390.0763144.7
 (SQL Overall)1786912395.88930343.2
 
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.