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

212 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
abuzz1551721(None) 
buzz146617801_buzz
abuse77119562abuse
abut66834952abu_t
abuts75417072abuts
fuzz158420572_fuzz
scuzz1537572scuzz
ab410674763ab___
aba512850953ab__a
abaca95118043abaca
abaci94718843abaci
aback134816173aback
abaft10318063abaft
abaka114313823abaka
abamp11310603abamp
abas68642083ab_as
abase76023483abase
abash106016513abash
abate76627843abate
abaya104413173abaya
abba810522653ab_ba
abbas95918643abbas
abbe87627193ab_be
abbes96723523abbes
abbey125714933abbey
abbot9318453abbot
abduce1197193abduce
abduct11108543abduct
abeam9316533abeam
abed79734133ab_ed
abele76323253abele
abet610547943ab_et
abets75621673abets
abhor10411063abhor
abide86223713abide
abjure1536743abjure
ablaze17239833ablaze
able66340533ab_le
abled86926833abled
abler75624313abler
ables75935543ables
ablush1147223ablush
ably99725133ab_ly
abmho1236793abmho
abo59045963ab__o
abode85518813abode
abohm1247973abohm
aboil72217543aboil
aboma91114603aboma
aboon74918703aboon
abort76133583abort
abos67734413ab_os
abound9239863abound
about75229083about
above105414323above
abri65522213ab_ri
abris75722603abris
abrupt1039943abrupt
abs59356073ab__s
absurd935903absurd
abulia83512503abulia
abulic106411423abulic
abused95614273abused
abuser85413683abuser
abuses85119103abuses
aby810238063ab__y
abye97921003ab_ye
abyes105518533abyes
abys97221883ab_ys
abysm12598143abysm
abyss10669463abyss
acute74720363acute
adoze155713833adoze
adult63520653adult
adunc837433adunc
adust64117453adust
adz1312332863a__dz
adze1412820573a_dze
agaze156113663agaze
ague55725923agu_e
agues64919053agues
ahull84010313ahull
ajuga1335883ajuga
album92312653albu_m
albums10198273albums
alula5317093alula
alum65227613alu_m
alums75720603alums
amaze166016603amaze
ambush1336113ambush
amu58237323amu__
amuck1389563amuck
amus65529613amu_s
amuse75920833amuse
anus47131113anu_s
aqua132813963aqu_a
aquae142212713aquae
aquas142412613aquas
arbute8311043arbute
arum66129033aru_m
arums75517833arums
auburn836213auburn
auk76234143a_u_k
auks85525263a_uks
auld54125363a_uld
aunt46553653a_unt
aura45836253a_ura
auto47432083a_uto
azo128233393a__zo
azuki1864803azuki
azure14911483azure
babu85829233babu__
babul96317713babu_l
babuls105413643babuls
babus95620333babu_s
baiza164813223baiza
baize164717393baize
baud74928423bau_d
bauds85821043bauds
baulk114914333baulk
biz147939363_b_iz
bize155926293_bize
bozo156821413_bozo
bub76343983_bu_b
bubo85621913_bubo
bubs86235503_bubs
bubu85022673_bubu
buck125129903_buck
bud67041273_bu_d
buds75235173_buds
buff125229863_buff
bug65340743_bu_g
bugs76035913_bugs
buhl95518223_buhl
buhr95315383_buhr
bulb85626693_bulb
bulk105426153_bulk
bull65634873_bull
bum75342693_bu_m
bumf116126513_bumf
bump106228243_bump
bums85934593_bums
bun56348143_bu_n
buna64730723_buna
bund75530663_bund
bung75730633_bung
bunk105731353_bunk
bunn65023653_bunn
buns66243723_buns
bunt65850853_bunt
buoy95921783_buoy
bur55744693_bu_r
bura66139533_bura
burb85334673_burb
burd75534263_burd
burg74930363_burg
burl64937183_burl
burn65636423_burn
burp85028883_burp
burr65631233_burr
burs65847423_burs
bury95633593_bury
bus56950973_bu_s
bush96630713_bush
busk105429223_busk
buss65134913_buss
bust65947783_bust
busy94727173_busy
but55963023_bu_t
bute66739673_bute
buts67247693_buts
butt65143743_butt
buy86436543_bu_y
buys95726793_buys
buzzed17408473_buzzed
buzzer16379113_buzzer
buzzes165011173_buzzes
fizz157519823_fizz
frizz165512623frizz
futz167823803_futz
fuze166422373_fuze
fuzzy1929814513_fuzzy
gauze155712973gauze
gauzy18489213gauzy
habu97325483habu__
habus106317143habu_s
halutz1868853halutz
huzza1646093_huzza
jacuzzi2441283jacuzzi
jazz193714463_jazz
kabuki1143963kabuki
klutz1868853klutz
lutz136826323_lutz
muzzy188410603_muzzy
ouzo133516933_ouzo
pazazz1554023pazazz
putz158326323_putz
quiz224920003_quiz
razz125219423_razz
scuzzy1933083scuzzy
spazz155811133spazz
tabu66328493tabu__
tabued94310403tabued
tabuli839363tabuli
tabun75914373tabu_n
tabuns8489223tabuns
tabus74820923tabu_s
whizz194210323whizz
yakuza2261873yakuza
yutz167519883_yutz
zuz1110622033_zu_z
zzz1017911913__zzz

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 Filter178691836670.1231452772.4
2DLD Change Limit836672126.50012871.8
3Display Results2122120.0633365.1
 (SQL Overall)1786912126.68626726.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.