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 “upprop” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
upprop94409(None) 
upprops1044221upprops
prop85932812__prop
upgrow1234272upgrow
uphroe1136082uphroe
approve14116603approve
apron7318833_apron
crop87628633__crop
drop75324403__drop
euphroe1245393euphroe
gumdrop1342513gumdrop
improv1344643improv
laptop1076813laptop
operon8811773operon
outcrop1146773outcrop
outdrop1036193outdrop
parol74826273_parol
perp89029893_per_p
pirog83913673_pirog
plop86625743__plop
poop86532813__poop
pop76252253__p_op
preop94715873_preop
prep86427673__prep
pro55837263__pro_
proa66229963__proa
prod76129503__prod
prof96134663__prof
prog75729003__prog
prom87631703__prom
props95726883__props
pros65742783__pros
prow97030383__prow
pyro96019393_pyro_
pyrope132810533_pyrope
pyros105718293_pyros
repro75315913repro_
repros84216003repros
riprap1055513riprap
strop77422243_strop
supercop1446463supercop
support11310523support
tiptop1036103tiptop
trop66833303__trop
unrip72012863u_nrip
unstop837473unstop
untrod769853untrod
unwrap11126323unwrap
upbore10247883upbore
upbow1245613u_pbow
updo76712883u_pdo_
updos8389513u_pdos
updry1135483updr_y
upflow1433523upflow
upfront1246973upfront
upgrew1233653upgrew
upgrown1343853upgrown
upgrows1334323upgrows
upheap13105213upheap
uphroes1236303uphroes
upkeep1434143upkeep
upleap10106843upleap
upo58925863u_p_o_
upon65817583u_p_on
upped103715163upp_ed
upper93714263upp_er
uppers102912293uppers
uppile10178503uppile
upping114013703upping
uppish1336633uppish
uppity1335103uppity
uppropped1242463uppropped
uproar8106933u_proar
uproot8314123uproot
uprose82311483u_prose
upshot1138453upshot
upslope1144173upslope
upstep1035503upstep
upthrow1543193upthrow
uptore8279453uptore
uptorn8268093uptorn
urp56426403u__r_p
usurp7106903usur_p

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.373479064.3
2DLD Change Limit112716835.76619548.4
3Display Results83830.0332515.2
 (SQL Overall)178691836.17228951.9
 
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.