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

229 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
jazzier223388(None) 
jazzer21376501jazz_er
dazzler1634712dazzler
dizzier16317542dizzier
fizzier18326712fizzier
fuzzier18256522fuzzier
gauzier1735632gauzier
hazier184712402ha_zier
jaggier16339182jaggier
jammier18408022jammier
jazzed22416292jazz_ed
jazzers22324762jazz_ers
jazzes21347882jazz_es
jazziest2333812jazziest
jazzily2533372jazzily
jazzing2333882jazzing
jazzmen2442502jazzmen
lazier154214612la_zier
mazier175013062ma_zier
muzzier17326552muzzier
snazzier1642482snazzier
achier113914263_achier
aerier64823153_aerier
airier64619363_airier
artier63419733_artier
ashier94714833_ashier
babier103515573ba_bier
baggier113611643baggier
balkier134111983balkier
balmier113811513balmier
barkier133814483barkier
barmier114313043barmier
barnier93213673barnier
barrier94017733barrier
battier93515713battier
bawdier13378203bawdier
boozier18349013boozier
brazier183911473brazier
buzzer16379113buzz_er
cagier93715933ca_gier
cahier113615773ca_hier
cakier123115243ca_kier
campier133313273campier
cannier94014163cannier
carrier93619583carrier
cashier123713323cashier
cattier93317073cattier
cozier173315143_cozier
crazier183610743crazier
crozier18369933crozier
daffier1457833daffier
dallier84215373dallier
dandier93714573dandier
dashier114311183dashier
daubier1037103daubier
dazzle1536853dazzle_
dazzled1735033dazzled
dazzlers1733233dazzlers
dazzles1636413dazzles
ditzier17307963ditzier
dizzied17236133dizzied
dizzies16279753dizzies
dozier163611633_dozier
earlier72612743earlier
easier64218463ea_sier
faddier1237783faddier
faggier12309843faggier
fancier123412063fancier
farrier103514893farrier
fattier103513463fattier
fawnier13296363fawnier
fizzer17369383fizz_er
fozier183710663_fozier
frizzier19284813frizzier
furzier19318103furzier
gabbier12379633gabbier
gambier124711973gambier
gamier93617933ga_mier
gammier123711193gammier
gappier12369843gappier
gassier83812573gassier
gaudier938453gaudier
gawkier15326523gawkier
gazer155720073ga_z_er
glazier17409353glazier
grazier173611133grazier
guzzler16286563guzzler
hairier103111053hairier
hammier143510653hammier
handier113817443handier
happier143312033happier
hardier114721543hardier
harrier104417753harrier
hastier103916623hastier
haulier1059943haulier
hazer174820233ha_z_er
jabber173713643ja_bber
jacker194417583ja_cker
jackies202912623jackies
jaeger14397193ja_eger
jager134318133ja__ger
jagger154016003ja_gger
jaggies163311083jaggies
jailer134316683ja_iler
jammer174014133ja_mmer
jammies183611293jammies
jangler153811833jangler
janglier1656113janglier
japer146218883ja__per
jasper154610383ja_sper
jauntier1535233jauntier
jazz193714463jazz___
jazzbo2342713jazz_bo
jazzbos2442033jazzbos
jazziness2432843jazziness
jazzlike2742683jazzlike
jazzman2442553jazzman
jazzy23396363jazz__y
jerkier18407273jerkier
jettier14358693jettier
jiggier16377823jiggier
jivier16438613j_ivier
jokier17618753j_okier
jollier142911003jollier
joltier14318493joltier
jowlier17327563jowlier
juicier1635463juicier
jumpier18317943jumpier
junkier18339493junkier
lacier84020093la_cier
lakier104716273la_kier
lambier113611643lambier
lankier113711633lankier
lardier83518343lardier
larkier113711523larkier
lathier10310833lathier
lazied164610653la_zied
lazies154418783la_zies
lezzie1435333lezzie_
lezzies1536203lezzies
malmier113611953malmier
maltier93015483maltier
mamzer19459833mamz_er
mangier104114063mangier
manlier92414023manlier
marlier92614773marlier
marrier93817523marrier
massier93615223massier
matier84321523ma_tier
mazer165722423ma_z_er
muzzler17257943muzzler
naggier9309153naggier
nappier114411173nappier
nastier74115293nastier
nattier73614623nattier
nuzzler15296493nuzzler
oakier104011393oa_kier
oozier153610253_oozier
pacier105018683pa_cier
palier85023563pa_lier
pallier94417163pallier
palmier113312173palmier
panier84425503pa_nier
pannier93613353pannier
panzer174213233panz_er
pappier103511593pappier
parrier93717653parrier
partier93520713partier
pastier94320383pastier
patzer173111643patz_er
pawkier16236613pawkier
puzzler17276963puzzler
racier85120973ra_cier
rainier71614263rainier
rallier73816273rallier
rammier112811023rammier
randier83618473randier
rangier83714353rangier
rapier84019993ra_pier
raspier93110643raspier
rattier74015593rattier
razer144824273ra_z_er
razzed15478283razz_ed
razzes144910073razz_es
razzing1636323razzing
ritzier16297203ritzier
rozzer1437353rozz_er
saggier92912063saggier
sagier73717163sa_gier
sallier73320423sallier
saltier74318633saltier
sandier84017843sandier
sappier113613113sappier
sarkier113413313sarkier
sassier73413233sassier
saucier9810283saucier
savvier1335483savvier
scuzzier1842713scuzzier
sizier1514813393_sizier
sizzler15266863sizzler
tackier133712523tackier
talkier114011843talkier
tallier72817213tallier
tangier83013903tangier
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tartier74123263tartier
tastier711817093tastier
tattier74216243tattier
tawnier10318463tawnier
tazze1339573tazz_e_
tizzies15287893tizzies
vampier14308233vampier
varier94619353va_rier
vastier103613203vastier
vizier184311023_vizier
wackier16369733wackier
wanier93920683wa_nier
warier93722893wa_rier
wartier103413913wartier
washier133611153washier
waspier12259053waspier
wavier124613083wa_vier
waxier16439903wa_xier
whizzier2233283whizzier
woozier19347323woozier
zanier154314713za_nier
zappier20458373zappier

Search took 7 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.390458182.1
2DLD Change Limit1340272296.45320769.7
3Display Results2292290.0763013.2
 (SQL Overall)1786912296.91925826.1
 
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.