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

138 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
upgrew123365(None) 
upgrow1234271upgrow
grew85620262__grew
outgrew1136712outgrew
pugree92112472pugree
regrew10388562regrew
undrew1037912undrew
upgrown1343852upgrown
upgrows1334322upgrows
upthrew1542662upthrew
agree65226033_agree
aigret73720023aigret
apres75426403ap_res
brew95023563__brew
crew96122683__crew
degree82814853degree
drew86221673__drew
eagre64315323eagre_
eagres74014573eagres
egret63327313_egret
gree56641563__gree
grey85624043__grey
grow86127303__grow
misgrew1335523misgrew
ogre56320743_ogre_
ogres65818633_ogres
outdrew1137143outdrew
outgrow1136323outgrow
pare66760843_pare_
pared86946763_pared
pareo74632603_pareo
parer75839903_parer
pares77164483_pares
pareu74928743_pareu
pere66450263_pere_
perea75026443_perea
peres76246643_peres
pew86442303_p__ew
phew128417113_p_hew
plew97222813_p_lew
pore66451263_pore_
pored85234513_pored
pores75849033_pores
pree67044733_p_ree
prep86427673_p_rep
prex135722973_p_rex
prey96228483_p_rey
prez156126313_p_rez
prow97030383_p_row
pugaree10208033pugaree
pugged114314533pugged
puggree11176113puggree
pugrees10218523pugrees
pure65543333_pure_
puree74632843_puree
purer75127903_purer
purge85324603purge_
purged104918263purged
purger94717233purger
purges94421763purges
purred94218073purred
pyre94925553_pyre_
pyres105523883_pyres
pyrex175211213_pyrex
redrew10309513redrew
regret73723533regret
regrow10309883regrow
screw109318543_screw
shrew119720173_shrew
spare75135563spare_
spared95427493spared
sparer84524963sparer
spares84834553spares
spew95421873sp__ew
spire75828693spire_
spirea84015633spirea
spired94921863spired
spirem104214163spirem
spires84628113spires
spore75428593spore_
spored94821793spored
spores84726613spores
spree74830863sp_ree
strew89220663_strew
supered10316123supered
threw1117315713_threw
umpire1047893umpire_
umpired1235783umpired
umpires1137813umpires
unbred92613303unbred
undraw1037813undraw
unfree9413203unfree
ungues7412123ungues
unmew103610073u_nmew
unpure82911533unpure_
unscrew1245463unscrew
unsew83912693u_nsew
upases84112903upases
upbore10247883upbore_
upbow1245613up_bow
upbye1244793upbye_
updried11226473updried
updries10209083updries
updry1135483updr_y
upflow1433523upflow
upgaze1833543upgaze
upgazed2033423upgazed
upgazes1933573upgazes
upgird10103933upgird
upgirded1342333upgirded
upgirds11103073upgirds
upgirt9117263upgirt
upgrade11215823upgrade
upgraded13215683upgraded
upgrades12216063upgrades
upgrowth1741953upgrowth
uphroe1136083uphroe
uphroes1236303uphroes
upkeep1434143upkeep
upped103715163up_ped
upper93714263up_per
uppers102912293uppers
upprop944093upprop
uprear8168793up_rear
upset73222593up_set
upstep1035503upstep
upthrow1543193upthrow
uptore8279453uptore_
uptrend1044293uptrend
urare56322553urare_
urares64519093urares
urea46528063u__rea
urge54722423urg_e_
urged75316033urg_ed
urger64116473urg_er
urgers73313623urgers
urges64619913urg_es
usurer638103usurer

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.406440125.6
2DLD Change Limit1127161385.39020912.1
3Display Results1381380.0334181.8
 (SQL Overall)1786911385.82930655.5
 
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.