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

147 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
uglify133391(None) 
uglily1036191uglily
gliff124915662_gliff
gulfy124612002gul_fy
ignify1334512ignify
nullify1334712nullify
qualify2235472qualify
salify12311372salify
uglier748952uglier
uglies7412322uglies
ugly86012382ugl__y
unify113611112u_nify
uplift114610652uplift
vilify1536772vilify
aerify122810113aerify
agility1148653agility
agley96917333agl_ey
agly86821803agl__y
alif76242143_alif_
alifs86121263_alifs
amplify1744083amplify
basify1437513basify
blimy125212823_blimy
bugling113615343bugling
burlily1237713burlily
calcify1735873calcify
calif104929103calif_
califs114915893califs
citify1437443citify
cliff135917133_cliff
cliffy17435243_cliffy
clift106422193_clift
coalify1536683coalify
codify1537163codify
curlily1238383curlily
deify124112763_deify
dignify1543893dignify
duality1147963duality
dulcify1643023dulcify
edify12308563_edify
falsify1643613falsify
fuggily1534963fuggily
fugling124212513fugling
gaily95020973_gaily
gasify1336333gasify
gift86735793_g_ift
gilly94321633_gilly
glady105413943_glady
glairy10448273_glairy
glary96018543_glary
glazy187410983_glazy
gley85724653_gl_ey
glia56423153_gli_a
glial66715433_glial
glias64618493_glias
glib79421443_gli_b
glibly1236293_glibly
glide74521593_glide
gliffs13436323_gliffs
glim76026353_gli_m
glime85620193_glime
glims87417673_glims
glint66830183_glint
glinty106910693_glinty
glitz154916373_glitz
glitzy19404783_glitzy
glorify1444583_glorify
glory96413293_glory
gluey95715263_gluey
gluily10308293_gluily
goofy124915623_goofy
griff124416463_griff
grift95924463_grift
grimy114312603_grimy
gripy115115253_gripy
guilty10418233guilty
gulf84929423gul_f_
gulfs94915303gul_fs
gulley104213163gulley
gully94020683gul_ly
gulpy114612763gul_py
holily123612953holily
jellify2054543jellify
jollify2044263jollify
justify2034663justify
kalif125021363kalif_
kalifs134410983kalifs
life75433733__life
lift76942723__lift
lignify1443793lignify
lily76730183__lily
limy95727713__limy
liny78141323__liny
magnify1634533magnify
minify1439253minify
modify1537173modify
mollify1555503mollify
muggily1435103muggily
mummify1643333mummify
nazify2134233nazify
nidify1336763nidify
nigrify1444133nigrify
notify1236943notify
nullity1037363nullity
ogling83211883ogling
oilily93111723oilily
ossify1244973ossify
pacify1667473pacify
policy133211513policy
polity113015863polity
purify14399153purify
quality1938563quality
ramify14268753ramify
rarify123210063rarify
ratify122610043ratify
reify114814973_reify
ruglike1236283ruglike
russify1334063russify
salsify1334703salsify
signify1444853signify
slily85820033_slily
slimy105417423_slimy
spliff1438603spliff
surlily10310003surlily
typify1734523typify
ugliest8410153ugliest
uglified1345293uglified
uglifier1244503uglifier
uglifies1246383uglifies
uglifying1743963uglifying
unity84918493u_nity
unlay84613703unl_ay
unlike102614063unlike
unlink104011013unlink
unlit55025463unli_t
unlive92712333unlive
untidy1059153untidy
uplifts12424773uplifts
uplink12388713uplink
uplit76020803upli_t
uppity1335103uppity
utility1038703utility
verify153110163verify
vinify1536923vinify
vivify1834703vivify
wilily123310763wilily
yuppify2042163yuppify

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.376475242.0
2DLD Change Limit1127161474.86023192.6
3Display Results1471470.0602450.0
 (SQL Overall)1786911475.29633740.7
 
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.