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

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

74 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
stupa7411231(None) 
stupas83910881stupas
stupe75217751stupe
pupa85422812_pupa
salpa75018352salpa
sauna54117552sauna
scuba94211592scuba
scup84822382scup_
scups95316652scups
scuta75815752scuta
setup73915822setup_
setups83910462setups
situp74414062situp_
situps8538782situps
skua86113152sku_a
soup66232912soup_
soups75322942soups
soupy106115402soupy
spa55730812s__pa
sputa74612962sputa
staph104314652staph
stela54019042stela
step67126292step_
steps76619882steps
stipe76523372stipe
stoa45425912st_oa
stoma75918272stoma
stop66532032stop_
stope74727242stope
stops74827282stops
stopt76528352stopt
stoup75517072stoup_
stoups85313272stoups
strap77925262strap
stria55723202stria
struma84313272struma
stub66221842stu_b
stubs75016072stubs
stuck114515772stuck
stud56220092stu_d
studs64415872studs
study94411792study
stuff113817052stuff
stull54916272stull
stum65526012stu_m
stump94616462stump
stumps104912282stumps
stumpy13458132stumpy
stums75320082stums
stun45623452stu_n
stung65417152stung
stunk94616292stunk
stuns54719492stuns
stunt55328172stunt
stupes84116952stupes
stupid937592stupid
stupor836012stupor
sturt56028962sturt
suba64926602s_uba
sup57041942s_up_
supe65932762s_upe
supra73614252s_upra
sups64834432s_ups
sura45740292s_ura
sutra54217932sutra
sutta54015332sutta
tapa65129142_tapa
tepa66021682_tepa
tsuba745562tsuba
tuba65422362_tuba
tufa75016612_tufa
tuna45127842_tuna
tup56037542_tup_
tups65628762_tups

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800741.72031279.1
3Display Results74740.0164625.0
 (SQL Overall)178691741.82997698.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.