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

224 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
updive123490(None) 
updived1434091updived
updives1334711updives
updove1234481updove
dive85634772__dive
endive103310472endive
undine7817262undine
unlive92712332unlive
update93810292update
uphove1436132uphove
uppile10178502uppile
uprise82313692uprise
upriver12196932upriver
upside9289802upside
upsize17267302upsize
uptime1067672uptime
active11313743active
aedile73716653aedile
aedine73218393aedine
alive85722513_alive
aplite8316393aplite
arrive91311793arrive
audile73315303audile
belive115415303belive
bodice11711423bodice
buppie12288733buppi_e
burdie93615023burdi_e
captive1438973captive
chive135117623_chive
codrive1337653codrive
cuddie104011173cuddi_e
cuplike1537213cuplike
cuprite1159683cuprite
cursive1237833cursive
dative10311813dative
deprive1338303deprive
derive103817043derive
dice75841893__dice
didie74120563didi_e
die46759653__di_e
dike95935763__dike
dime76237643__dime
dine55555333__dine
dire56644143__dire
dite55547553__dite
diva85920883__diva
dived106321373__dived
diver94827803__diver
dives95832403__dives
dove85131563__dove
drive95318003_drive
duddie9348863duddi_e
edile64819493_edile
endite73817593endite
endives113710693endives
eruptive1345793eruptive
five107629743__five
furtive1337173furtive
give85829353__give
glaive10357933glaive
hive106029673__hive
indie63721473indi_e
indite73520323indite
iodide84812933iodide
iodine74618653iodine
iodise74214943iodise
iodize164112593iodize
jive146123593__jive
jussive1734293jussive
khedive1842503khedive
live76540993__live
lupine84013533lup_ine
mediae94217413mediae
motive113112143motive
naive85116213_naive
native9613013native
nudie65118673nudi_e
ogive9379093_ogive
oldie6415473oldi_e
olive84817153_olive
ophite11410563ophite
opine77422463op_ine
optime1079353optime
outdrive1236893outdrive
outgive11199253outgive
outlive102513033outlive
paise75028333_paise
parve109824853_parve
pave96133893_p_ave
peeve104915253_peeve
peise75825773_peise
pice84641093_p_ice
pie55457403_p_i_e
pike106335213_p_ike
pile65649693_p_ile
pine67755713_p_ine
pipe86434433_p_ipe
plie65127393_pli_e
podite93315353podite
poise75127893_poise
poove104514303_poove
predive13511083predive
price93725413_price
pride84724733_pride
prime96525603_prime
prise74632613_prise
privet113821343_privet
privy13439833_privy
prize164718943_prize
prove104823193_prove
puddle103914153puddle
pudic104614563pudi_c
pumice1238223pumice
purine85321893purine
rediae74221993rediae
redrive112410563redrive
regive104814323regive
reive85522943_reive
relive95120783relive
revive124914823revive
rive75537723__rive
scrive115414943scrive
sedile73517233sedile
shive114423423_shive
shrive125216953shrive
skive124614113_skive
skydive1852773skydive
spavie113611383spavie
speise84614253speise
spice95528813sp_ice
spike114922843sp_ike
spile75230083sp_ile
spine76534423sp_ine
spire75828693sp_ire
spite75430663sp_ite
spiv95917793sp_iv_
spivs105114243sp_ivs
splice104915103splice
spline86020533spline
sprite84421773sprite
strive95020963strive
suasive1037853suasive
supine84216693sup_ine
survive1335933survive
swive115316193_swive
tardive1136893tardive
thrive125313223thrive
turdine8310283turdine
tussive1035303tussive
umpire1047893umpire
unciae83215313unciae
unde55825483und__e
undee65327273und_ee
undid72415363undi_d
undies73821963undies
undines8716083undines
undone7914253undone
undue66715553und_ue
unite54828383u_nite
unitive10310563unitive
unlike102614063unlike
unlived112511373unlived
unlives102010953unlives
unpile81914323unpile
unripe82012093unripe
unrove92511683unrove
untie54425493unti_e
unwise9510803unwise
unwove12238883unwove
upbind11246313upbind
upbore10247883upbore
upbye1244793up_bye
upcurve1463273upcurve
updart9310743updart
updated11369423updated
updater10347253updater
updates10329793updates
updiving1534223updiving
updo76712883upd__o
updos8389513upd_os
updried11226473updried
updries10209083updries
updry1135483upd_ry
upgaze1833543upgaze
upgird10103933upgird
upgirt9117263upgirt
upheave1544023upheave
uphill11106173uphill
uphroe1136083uphroe
uplift114610653uplift
uplink12388713uplink
uplit76020803upli_t
uppiled12216593uppiled
uppiles11208263uppiles
upping114013703upping
uppish1336633uppish
uppity1335103uppity
upraise9158603upraise
uprate83916543uprate
uprisen9227353uprisen
upriser9218763upriser
uprises92012733uprises
uprivers13215563uprivers
uprose82311483uprose
upsides10319633upsides
upsized19246253upsized
upsizes18297163upsizes
uptake1236963uptake
uptick1436763uptick
uptilt8410803uptilt
uptimes1177553uptimes
uptore8279453uptore
upwind12255823upwind
ureide7310363ureide
uridine81311213uridine
urine55026603u_rine
ursine64114123ursine
utile54718933u_tile
visive1257873visive
vive105426623__vive
votive12348933votive
waive114214603_waive
wive105931753__wive
yuppie13297133yuppi_e

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 Limit1127162245.98618829.9
3Display Results2242240.0762947.4
 (SQL Overall)1786912246.45227695.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.