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

220 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
updives133471(None) 
updive1234901updive_
updived1434091updived
dives95832402__dives
endives113710692endives
undies73821962undi_es
undines8716082undines
unlives102010952unlives
updates10329792updates
updove1234482updove_
updries10209082updries
uppiles11208262uppiles
uprises92012732uprises
upriver12196932upriver
uprivers13215562uprivers
upsides10319632upsides
upsizes18297162upsizes
uptimes1177552uptimes
actives12311523actives
aediles83413903aediles
aphides134711203aphides
apices104916263ap_ices
aplites9314933aplites
apsides103911303apsides
arrives101311513arrives
audiles83112613audiles
bodices12710593bodices
bodies94524143bodi_es
buddies113914353buddi_es
buppies133011063buppi_es
burdies104117563burdi_es
captives1538623captives
chives144317593_chives
codices12512583codices
codrives1437663codrives
cuddies113313263cuddi_es
cuprites1259023cuprites
cursives1337103cursives
datives11310073datives
deprives1438393deprives
derives114017813derives
dices86434243__dices
didies84621833didi_es
dies55653523__di_es
dikes105831333__dikes
dimes85833043__dimes
dines66449153__dines
dites66339153__dites
divas95418583__divas
dive85634773__dive_
dived106321373__dived
diver94827803__diver
divers105024963__divers
divest106820073__divest
doves94728153__doves
drives105117113_drives
eddies83313163eddi_es
ediles74016983_ediles
endites83717063endites
endive103310473endive_
eruptives1443853eruptives
fives116027363__fives
fuddies123211203fuddi_es
gives95324873__gives
glaives11347833glaives
guppies123310523guppi_es
hives116925513__hives
hurdies114015663hurdi_es
huswives1742933huswives
indices103513443indices
indies73822783indi_es
indites83618983indites
iodides93811613iodides
iodines83616633iodines
iodises83413633iodises
iodizes173911723iodizes
jives154820813__jives
jussives1833843jussives
khedives1942183khedives
knives13458553_knives
ladies75124883ladi_es
lives86133193__lives
lupines93912503lup_ines
midlives14287463midlives
midwives17274803midwives
motives123611893motives
muddies113513953muddi_es
naives94914223_naives
natives10310823natives
nudies75217093nudi_es
ogives10367913_ogives
oldies7314423oldi_es
oldwives1542463oldwives
olives94313953_olives
ophites12310103ophites
opines84820703op_ines
optimes1148473optimes
ordines83014903ordines
outdrives1346703outdrives
outgives12218623outgives
outlives112511763outlives
paves104833923_p_aves
peeves113814873_peeves
peises84125043_peises
pelves114514663_pelves
phizes20389133_phizes
pies66949603_p_i_es
pikes115031033_p_ikes
piles74742613_p_iles
pines76048863_p_ines
pipes96030143_p_ipes
pixes144323173_p_ixes
plies74526513_pli_es
podites103014733podites
poises84226543_poises
pooves113914713_pooves
prices104524543_prices
prides94324183_prides
pries74339533_pri_es
primes104225263_primes
prises84133173_prises
privet113821343_privet
privets122910053_privets
privies122414263_privies
prizes173819813_prizes
proves114322253_proves
puddles113613823puddles
pumices1338273pumices
puppies103212623puppi_es
purines94420763purines
radices102314263radices
radixes15259343radixes
redrives122610393redrives
regives115014213regives
reives95723043_reives
relives104619443relives
revives134715543revives
rives85336003__rives
scrives124414273scrives
shives124921413_shives
shrives134416173shrives
skives134113943_skives
skydives1952133skydives
spadices1336093spadices
spadixes1834113spadixes
spavies123012953spavies
speises93813933speises
spices104326033sp_ices
spies76037623sp_i_es
spikes124520713sp_ikes
spiles84227913sp_iles
spines85132033sp_ines
spires84628113sp_ires
spites84127333sp_ites
spivs105114243sp_iv_s
splices113914383splices
splines94718893splines
sprites94220333sprites
strives104119373strives
supines94216383sup_ines
survives1436333survives
swives123915183_swives
thrives134611713thrives
tidies74721833tidi_es
todies74223553todi_es
uglies7412323ugli_es
umpires1137813umpires
undine7817263undine_
undoes73917403und_oes
unfixes17238113unfixes
unites65024853u_nites
unlive92712333unlive_
unlived112511373unlived
unmixes16197753unmixes
unpiles92112783unpiles
unties64326923unti_es
upases84112903up_ases
upbinds12234813upbinds
upcurves1583153upcurves
updarts1034203updarts
update93810293update_
updated11369423updated
updater10347253updater
updaters11255183updaters
updiving1534223updiving
updos8389513upd__os
updried11226473updried
upgazes1933573upgazes
upgirds11103073upgirds
upheaves1643913upheaves
uphills1295233uphills
uphove1436133uphove_
uphroes1236303uphroes
uplifts12424773uplifts
uplinks13345613uplinks
uppile10178503uppile_
uppiled12216593uppiled
uppings12257123uppings
upraises10188473upraises
uprates93814863uprates
uprise82313693uprise_
uprisen9227353uprisen
upriser9218763upriser
uprisers10206773uprisers
upside9289803upside_
upsize17267303upsize_
upsized19246253upsized
uptakes1336593uptakes
upticks1535153upticks
uptilts934733uptilts
uptime1067673uptime_
upwinds13224223upwinds
ureides8311103ureides
uridines989513uridines
urines64724123u_rines
votives13337953votives
wadies105121203wadi_es
waives123714183_waives
wives115328923__wives
yuppies14339263yuppi_es

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272206.64320175.7
3Display Results2202200.0762894.7
 (SQL Overall)1786912207.12525079.4
 
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.