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

84 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
stemson94516(None) 
stemsons1045001stemsons
stepson945671stepson
stetson745781stetson
season62714902s_eason
stems75219952stems__
stepsons1045662stepsons
sternson844842sternson
stetsons845622stetsons
telson6310292_telson
crimson1135643crimson
daemon9279593daem_on
damson938063_damson
demon86520313_dem_on
etymon1134693etym_on
items7499613items__
keelson1153993keelson
kelson1038153_kelson
lemon75618183_lem_on
lesson64412043_lesson
meson74118313_me_son
nelson638423_nelson
person83517873_person
ramson8310463_ramson
reason62616333_reason
salmon84614183salm_on
seasons72614233s_easons
seems75525023seems__
seisin63715123s_eisin
seisor63712343s_eisor
selsyn983843s_elsyn
semen75724103s_em_en
sensor63813843s_ensor
sermon8413553s_ermon
session739763s_ession
seton55223543s_e_ton
sexton133610793s_exton
simoon858063s_imoon
sponson935383sponson
stamen84115943stam_en
station72717243station
steams84916903steams__
steapsin1044713steapsin
stearin7312003stearin
steepen9348653steepen
stegodon1042473stegodon
stein54620543ste__in
stem610628253stem___
stemma10328133stem_ma
stemmas11256973stemmas
stemmed12278153stemmed
stemmer113210183stemmer
stemming13408203stemming
stemmy13417033stem_my
steno54716863ste_no_
stenos63915773ste_nos
stentor739383stentor
steps76619883steps__
stereo65317913stereo_
stereos74314973stereos
stern55319123ste__rn
sternsons944663sternsons
sterol6613333ste_rol
stertor7310093stertor
stets55423913stets__
stewpan1234193stewpan
stews85519143stews__
stolon64112073st_olon
stonemason1251873stonemason
stressor875543stressor
stums75320083stums__
summon1037623s_ummon
tampon102911233_tampon
teflon937453_teflon
telsons739223_telsons
tempo95214973_tempo_
tempos103812293_tempos
tendon7312033_tendon
tenon53320513_te_non
tension7311803_tension
tensor63812673_tensor
teston6313303_teston
treason748763treason
weason93210823_weason

Search took 8 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.403443402.0
2DLD Change Limit134027847.20318607.1
3Display Results84840.0332545.5
 (SQL Overall)178691847.63923391.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.