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

120 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
ugsome93478(None) 
fulsome1245362fulsome
gnome84213952_gnome
some66040382__some
wagsome1345212wagsome
agnomen1036763agnomen
agone65924553ag_one
assume897563assume
autosome1047793autosome
awesome1245573awesome
become123312593become
besom95716973besom_
besoms105712733besoms
biome94916993_biome
bosom95516923bosom_
bosomed1238003bosomed
bosoms104913053bosoms
bosomy13509033bosomy
brome94421973_brome
chrome133214813chrome
cleome1039083cleome
come87547703__come
disme85716243dis_me
distome10313233distome
dome77240733__dome
episome1157813episome
eyesome1246163eyesome
foursome1344673foursome
game76644323_g_ame
genome94312193genome
geode7412593_geode
gimme102411343_gimme
glime85620193_glime
globe84917013_globe
glom75424383_glom_
gloms85219783_gloms
glove94516293_glove
gloze154815983_gloze
glume85120463_glume
gnomes93812973_gnomes
gomer85220653_g_omer
gone55639043_g_one
goose65925903_goose
gore55744963_g_ore
grime85021323_grime
grope84821613_grope
grove95219333_grove
gruesome1144283gruesome
grume86218163_grume
gussie72910153gussie
home98042443__home
ignore7269063ignore
income10712093income
insole63515863insole
irksome1344373irksome
isomer8310153_isomer
lissome937583lissome
longsome1145933longsome
mome85239353__mome
noisome947973noisome
nome66038423__nome
outcome11310573outcome
outsole71013433outsole
oxysome1944213oxysome
pome85636693__pome
posole8314223posole
psoae74411623_psoae
radome9511873radome
resole64624183resole
resume8313783resume
rugose737283rug_ose
same65245643__same
seme65836653__seme
sesame8311013sesame
soke85436263__soke
sole46053673__sole
som59153813__som_
soma65635293__soma
soms66239373__soms
sone46649983__sone
sore47059533__sore
subsume1146713subsume
telome8311923telome
tome67543193__tome
trisome9310223trisome
tussore7317283tussore
twasome1244623twasome
twosome1245303twosome
undone7914253undone
unglove1136103unglove
unrobe82611673unrobe
unrove92511683unrove
unsafe9310693unsafe
unsober967643unsober
unsold71410513unsold
unsowed112511053unsowed
unsown9328433unsown
unspoke1336573unspoke
unsure62815413unsure
unswore1039053unswore
untame82513603untame
unwove12238883unwove
unyoke1367293unyoke
upbore10247883upbore
updove1234483updove
uphove1436133uphove
uprose82311483uprose
upside9289803upside
upsize17267303upsize
upslope1144173upslope
upsoar8105683upsoar
uptime1067673uptime
uptore8279453uptore
ursae55214453urs_ae
ursine64114123ursine
usage6410213u_sage
use36835163u_s__e
usque14137733u_sque
winsome1237463winsome
woesome1246733woesome

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161206.51617298.3
3Display Results1201200.0432790.7
 (SQL Overall)1786911206.94925714.6
 
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.