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

189 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
augury1036666(None) 
augur64311211augur_
augurs7399961augurs
angary10311322angary
angry9310862ang_ry
argufy1344092argufy
auburn836212auburn
auger64922472auger_
augers73818702augers
augural856402augural
augured987192augured
augurer8136342augurer
august739202august
luxury1642542luxury
puggry13374822puggry
sugary1039012sugary
usury887622_usury
abjure1536743abjure
absurd935903absurd
actuary1245613actuary
adjure1435843adjure
aery77231683a__ery
agar58726413a_gar_
agars66120643a_gars
ager55935843a_ger_
agers65027853a_gers
agger76420893agger_
aggers85817793aggers
aggro738013a_ggro
agley96917333a_gley
agly86821803a_g_ly
agony96415653a_gony
agora6914333a_gora
agouty10366913agouty
ague55725923a_gu_e
agues64919053a_gues
airy75734153a__iry
alary86123443a_lary
algor6513053algor_
algors7312553algors
algum82711763algu_m
algums9208043algums
allure63012943allure
ambary134010543ambary
ambery133811133ambery
ambry123512103a_mbry
amour75014853amour_
amours83512663amours
anger66225873anger_
angerly1137773angerly
angers75222543angers
angora71111573angora
apery106517903a_pery
apiary113910383apiary
argosy1036423argosy
argue64818443argu_e
argued84311173argued
arguer74510543arguer
arguers8489033arguers
argues74516413argues
argus66716543argu_s
ariary94114203ariary
armory114211473armory
armoury12376233armoury
armure8710133armure
artery9911453artery
arugula843913arugula
assure6610773assure
auburns935573auburns
aucuba1045493aucuba
augend837633augend
aught95120703aug_ht
aughts104710243aughts
augite7312613augite
augurers9114813augurers
auguries947933auguries
auguring1036383auguring
augustly1242153augustly
auntly95211063auntly
aunty85919813au_nty
aura45836253a__ura
aurar54420253aurar_
aurora6411763aurora
aurum7614963auru_m
aurums849383aurums
ausubo853653ausubo
autarky1444703autarky
auteur6107943auteur_
auteurs7137503auteurs
autumn836013autumn
aviary12338413aviary
aweary1237303aweary
awry107619683a__wry
azure14911483a_zure
buggery14367933buggery
buggy124613483bug_gy
bulgur9387533bulgur_
bulgurs10397113bulgurs
burry105221563bu_rry
bury95633593__bury
cautery12349593cautery
curry105920343cu_rry
daubery13396213daubery
daubry12445483dau_bry
decury1277963decury
dupery12378743dupery
figure10258833figure
fleury12417353fleury
floury12449573floury
fuggy135411673fug_gy
fugu85419863fugu__
fugue94313373fugu_e
fugued11478713fugued
fugues104511683fugues
fugus95914013fugu_s
furry116719283fu_rry
fury107727973__fury
future939563future
gaudery1234743gaudery
gauger84714853gauger_
gaugers94211713gaugers
gauntry1154113gauntry
gory86129663__gory
gurry94515413gu_rry
guru54623913__guru
guy75728943__gu_y
haughty17334643haughty
hugely1336803hugely
huger94914873huger_
hungry1334973hungry
hurry114917183hu_rry
injury16266143injury
jaggary19304863jaggary
jaggery19336903jaggery
jugula1434983jugula
jugum15167473jugu_m
jugums16104673jugums
jury146719593__jury
kaury12429763_kaury
langur7109303langur_
langurs889103langurs
laundry1133513laundry
ligure7279473ligure
loury85716753_loury
luger65322083luger_
lugers74617023lugers
maguey1236833maguey
mauger93813483mauger_
maugre9308973maug_re
muggur10325593muggur_
muggurs11315103muggurs
muggy125612373mug_gy
murry105120233mu_rry
naughty14445623naughty
ouguiya1141493ouguiya
outcry1137993outcry
paughty16294323paughty
penury1148103penury
puggy124612323pug_gy
quarry1837473quarry
query174212083qu_ery
rebury11349213rebury
roguery1134893roguery
rudery10419033rudery
rugby11448133rug_by
sauger74316253sauger_
saugers83914053saugers
saughy13507463saug_hy
saury84317223_saury
savoury13365873savoury
stoury9529943stoury
suburb1037163suburb
sudary1038703sudary
sugar6312913sugar_
sugars7312423sugars
sulfury1345163sulfury
sultry938463sultry
sundry1057943sundry
surgery11319213surgery
suture6313203suture
ugly86012383_ug_ly
unary8315993_unary
updry1135483_updry
usurp7106903_usurp
vagary1337333vagary
vapoury15284803vapoury
vuggy13589483vug_gy
waggery15276903waggery
yogurt1037823yogurt

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.1401276364.3
2DLD Change Limit1127161897.40615219.6
3Display Results1891890.0633000.0
 (SQL Overall)1786911897.60923484.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.