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

98 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
seam66645971seam_
seams75731661seams
seamy105921271seamy
seat47575561sea_t
beam86939232beam_
beams95328172beams
beamy126218572beamy
beast76338642beast
beat66168302bea_t
beaut75135212beaut
dealt65234282dealt
dreamt94615712dreamt
east46659102_east
eat36989052_ea_t
feast85932722feast
feat76458222fea_t
heart85440742heart
heat77061422hea_t
leant56737782leant
leapt75027472leapt
least56134882least
meant76537212meant
meat66359602mea_t
neat46356782nea_t
peart76440752peart
peat65967932pea_t
react74634332react
ream65841612ream_
reams75729622reams
salt45758522s_alt
same65245642s_ame
samp85733592s_amp
sat36288482s_a_t
scam85932352scam_
scamp115717312scamp
scams94423972scams
scant79735072scant
scart76139772scart
scat65848372sca_t
scatt76030092scatt
sea36161292sea__
seal45654372sea_l
seals54839692seals
seaman84015902seaman
seamed94823882seamed
seamen84518562seamen
seamer84223612seamer
sear47353842sea_r
sears54744912sears
seas45755272sea_s
seats54844342seats
secant84023292secant
sect67443622se_ct
seem65438562seem_
seems75525022seems
sejant133114482sejant
seme65836652se_me
semi65127222se_mi
sent46963012se_nt
sept65844362se_pt
sesame8311012sesame
set36681252se__t
sett45949052se_tt
sext117338092se_xt
shaft115725262shaft
shalt85534492shalt
sham96436362sham_
shame105726702shame
shams105829412shams
shat76456602sha_t
skat87037902ska_t
slam67737972slam_
slams74927902slams
slant55238702slant
slat46959022sla_t
smalt74729332smalt
smart75834092smart
spait75631602spait
spam85930042spam_
spams94922192spams
spat66548522spa_t
stamp95217362stamp
start55642312start
stat47352692sta_t
steam76322932steam_
steams84916902steams
steamy115112372steamy
swam96329982swam_
swami105614522swami
swamp125015322swamp
swamy136714402swamy
swart86234642swart
swat77244442swa_t
sweat85628402swea_t
team66238652team_
teams75726512teams
teat45963632tea_t
yeast85327942yeast

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.0961861364.6
2DLD Change Limit53800981.53035163.4
3Display Results98980.0166125.0
 (SQL Overall)178691981.642108825.2
 
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.