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

113 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
upgrows133432(None) 
upgrow1234271upgrow_
upgrown1343851upgrown
grows95523922__grows
outgrows1236282outgrows
prows106327012_p_rows
regrows11269152regrows
upbows1384682up_bows
upflows1543512upflows
upgrew1233652upgrew_
upgrowth1741952upgrowth
upgrowths1851332upgrowths
uphroes1236302uphroes
upprops1044222upprops
upthrows1643302upthrows
aggros836553aggro_s
aprons8316993ap_rons
arrows92813483_arrows
barrows123411683barrows
borrows12349253borrows
brows105425983__brows
burrows12399093burrows
crows105727313__crows
cuprous1149743cup_rous
engross837123engross
escrows1235803escrows
euphroes1345993euphroes
farrows13259783farrows
fogbows1643853fogbows
frows116623103__frows
furrows13327793furrows
glows95518033__glows
grogs76319413__grogs
groks105716123__groks
gross65421693__gross
grots65025853__grots
grow86127303__grow_
growl96115823__growl
growls104711113__growls
grown95317353__grown
harrows132611033harrows
ingrown1145393ingrown
marrows122911823marrows
misgrows1444963misgrows
morrows12318723morrows
narrows10258843narrows
operons91411743operons
outcrows1346653outcrows
outglows1244933outglows
outgross936423outgross
outgrow1136323outgrow_
outgrown1245093outgrown
outrows10311403outrows
parols84722613_parols
parous84024163_parous
plows105419903_p_lows
pogroms1237643pogroms
porous84419483_porous
pows95537663_p__ows
proas75028803_p_roas
prods85523553_p_rods
profs105120893_p_rofs
progs86624153_p_rogs
proms95426413_p_roms
props95726883_p_rops
pros65742783_p_ro_s
pross76529403_p_ross
prow97030383_p_row_
prowl105615123_p_rowl
prowls115511083_p_rowls
pugrees10218523pugrees
pyros105718293_pyro_s
reglows11288843reglows
regrow10309883regrow_
regrown11237363regrown
rows75941753___rows
serows96016393_serows
sorrows10278403sorrows
sparrows1344803sparrows
strows96718273_strows
sunglows1244083sunglows
throws129715233_throws
trows88826183__trows
uncross938193uncross
uncrown1236323uncrown
uncrowns1344363uncrowns
undraws1136893undraws
upbow1245613up_bow_
updos8389513up_do_s
updries10209083updries
upflow1433523upflow_
upfront1246973upfront
upgazes1933573upgazes
upgirds11103073upgirds
upgrade11215823upgrade
upgrades12216063upgrades
upgrowing1643123upgrowing
uphroe1136083uphro_e
upprop944093uppro_p
uproar8106933up_roar
uproars986453up_roars
uproot8314123up_root
uproots937143uproots
uprose82311483up_rose
uprouse937223up_rouse
upshots1235193upshots
upthrow1543193upthrow_
upthrown1642593upthrown
uptoss836093up_toss
uptown11274963up_town
uptowns12194343up_towns
vrows116115263__vrows
yarrows13277853yarrows

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271136.50020619.5
3Display Results1131130.0333424.2
 (SQL Overall)1786911136.95325699.8
 
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.