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

185 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
snazzy173401(None) 
jazzy23396362_jazzy
scuzzy1933082scuzzy
snaggy11488052snaggy
snakey135011272snakey
snaky125113912sna_ky
snappy1366102snappy
snarky134210842snarky
snarly93815002snarly
sneezy18345272sneezy
snoozy18517232snoozy
spazz155811132spazz_
anally9513503anally
crazy195511223cra_zy
dizzy177410853_dizzy
fezzy199811453_fezzy
fizzy199015083_fizzy
frizzy20555833frizzy
fuzzy1929814513_fuzzy
gauzy18489213_gauzy
glazy187410983gla_zy
gnarly104610383gnarly
gnatty10336483gnatty
hazy1918119193_ha_zy
jazz193714463_jazz_
knarry1334613knarry
lazy166423073_la_zy
lezzy16608083_lezzy
mazy186419703_ma_zy
muzzy188410603_muzzy
naggy106612823_naggy
nancy105214923_nancy
nanny84813813_nanny
nappy126312333_nappy
narky126017803_narky
nary76931223_na_ry
nasty85717283_nasty
natty85719143_natty
navvy14696683_navvy
navy107518633_na_vy
nay66952773_na__y
nazi136219873_na_zi
nazify2134233_nazify
nazis145216083_nazis
piazza1643823piazza
piazze1634683piazze
pizazzy1952243pizazzy
razz125219423_razz_
sadly94519123s_adly
saggy105917463s_aggy
sagy85327083s_a_gy
sally85129713s_ally
salty85524383s_alty
sandy94221133s_andy
sanely93114613sanely
sanity9316203sanity
sappy125413473s_appy
sarky125521783s_arky
sassy85813813s_assy
satay84718463s_atay
saucy104615163s_aucy
saury84317223s_aury
savoy114713883s_avoy
savvy14497503s_avvy
say67264763s_a__y
scabby1535503scabby
scaly104718723sca_ly
scanty114014663scanty
scarey115016983scarey
scarry116311183scarry
scary105222593sca_ry
scatty115310653scatty
schizy23115043schizy
schizzy23132363schizzy
scuzz1537573scuzz_
seamy105921273sea_my
seaway12309993seaway
senary93716073sena_ry
shabby1635803shabby
shady125416513sha_dy
shaggy14478043shaggy
shaky154616843sha_ky
shaley123714993shaley
shaly114322863sha_ly
shammy16388503shammy
shamoy14379913shamoy
shandy134710033shandy
shanny124110093shanny
shanty124715123shanty
sharny124711833sharny
sharpy145211033sharpy
shay107133343sha__y
shazam2046623shazam
sizy164816393s__izy
skanky12476963skanky
slaggy11438793slaggy
slangy105411393slangy
slanty95114843slanty
slatey95417063slatey
slaty86523153sla_ty
slavey124011803slavey
slay76436383sla__y
sleazy18267393sleazy
smarmy13629353smarmy
smarty115013793smarty
smaze165012933sma_ze
smazes174311663smazes
snack114718063sna_ck
snacks124514553snacks
snafu8412143sna_fu
snafus936743snafus
snag55827873sna__g
snags64421313sna_gs
snail57020203sna_il
snails64816653snails
snake94821113sna_ke
snaked115017593snaked
snakes103919603snakes
snakily1436913snakily
snap65727033sna__p
snaps74719563sna_ps
snare54429983sna_re
snared74824553snared
snarer64620843snarer
snares65329033snares
snarf86525423sna_rf
snarfs95113423snarfs
snark95419943sna_rk
snarks104815733snarks
snarl54921083sna_rl
snarls64016873snarls
snash84815673sna_sh
snatch114310603snatch
snatchy15355293snatchy
snath86419803sna_th
snathe94415113snathe
snaths95112913snaths
snaw78923073sna__w
snawed104813733snawed
snaws86116363sna_ws
snazzier1642483snazzier
sneaky13427843sneaky
sneery93610413sneery
sneeze15318523sneeze
sniffy15337193sniffy
snippy1374843snippy
snobby1334403snobby
snoopy11449473snoopy
snooty94211513snooty
snooze15439993snooze
snotty9489203snotty
snouty9419953snouty
snowy115011563sn_owy
snubby1344533snubby
snuffy15356243snuffy
snugly1055663snugly
soapy106114783soa_py
spacey136212533spacey
spacy125415623spa_cy
sparky154511523sparky
sparry115111303sparry
spay96631663spa__y
spaz155626163spa_z_
spazzes1735263spazzes
stably113314123stably
stagey105915583stagey
staggy115510393staggy
stagy96618893sta_gy
stalky13499303stalky
stanza1537073stanza
starry94911673starry
stay78333723sta__y
suably112814533suably
swabby1634353swabby
swampy16437233swampy
swamy136714403swa_my
swanky16447973swanky
swanny12336823swanny
swarty125812383swarty
sway107128233swa__y
tazza1338083_tazza
tazze1339573_tazze
tizzy16548893_tizzy
unary8315993una_ry
whizzy23274073whizzy

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 Filter1786911127160.483369960.7
2DLD Change Limit1127161857.14015786.6
3Display Results1851850.0632936.5
 (SQL Overall)1786911857.68623248.9
 
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.