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

99 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
stump9461646(None) 
slump94816631slump
stamp95217361stamp
stomp95616661stomp
stum65526011stum_
stumps104912281stumps
stumpy13458131stumpy
stums75320081stums
sump86331531s_ump
tump85927031_tump
bump106228242_bump
chump145315442chump
clump115517452clump
crump115616422crump
dump95927092_dump
flump124614722flump
frump126912562frump
grump105115312grump
hump116228722_hump
jump156621722_jump
lump86531702_lump
metump1235712metump
mump105425722_mump
plump115315262plump
pump105726852_pump
rump86729082_rump
samp85733592s_amp
scamp115717312scamp
sculp95314842sculp
scum85924522scum_
scums95017422scums
scup84822382scu_p
setup73915822setu_p
shlump1345712shlump
simp85228772s_imp
situp74414062situ_p
skimp135411312skimp
slum65430512slum_
slumps104313582slumps
slums74623432slums
slurp74014982slurp
soup66232912sou_p
spume95817312spume
spumy124610362spumy
stamps105614022stamps
steep76020702steep
stem610628242stem_
stems75219952stems
step67126292st_ep
stime76521792stime
stimy105114732stimy
stirp76815502stirp
stoma75918272stoma
stomps105612832stomps
stoop75821542stoop
stop66532032st_op
stoup75517072stoup
stowp105614232stowp
strap77925262strap
strep77120852strep
strip77524332strip
strop77422242strop
strum75619442strum_
struma84313272struma
strums84716452strums
stub66221842stu_b
stubs75016072stubs
stuck114515772stuck
stud56220092stu_d
studs64415872studs
study94411792study
stuff113817052stuff
stull54916272stull
stumped124210152stumped
stumper113610092stumper
stun45623452stu_n
stung65417152stung
stunk94616292stunk
stuns54719492stuns
stunt55328172stunt
stupa74112312stupa
stupe75217752stupe
sturt56028962sturt
stymy13358292stymy
sum56346012s_um_
sumo67326312s_umo
sumps95023432s_umps
sums65837582s_ums
sup57041942s_u_p
swamp125015322swamp
swum96416822swum_
tamp86133002_tamp
temp85323332_temp
thump126211572thump
trump95615122trump
tumps95420792_tumps
tup56037542_tu_p
ump76130442__ump
whump154910042whump

Search took 5 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 Limit53800994.00013450.0
3Display Results99990.0801237.5
 (SQL Overall)178691994.17342820.8
 
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.