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

88 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
stepson94567(None) 
stemson945161stemson
stepsons1045661stepsons
stetson745781stetson
season62714902s_eason
steapsin1044712steapsin
stemsons1045002stemsons
steps76619882steps__
sternson844842sternson
stetsons845622stetsons
telson6310292_telson
crepon1039943crep_on
erepsin937383erepsin
ethephon1643473ethephon
keelson1153993keelson
kelson1038153_kelson
lepton82510803_lepton
lesson64412043_lesson
meson74118313_me_son
nelson638423_nelson
pepsin10310853_pepsin
person83517873_person
reason62616333_reason
seasons72614233s_easons
seeps74828753seeps__
seisin63715123s_eisin
seisor63712343s_eisor
selsyn983843s_elsyn
sensor63813843s_ensor
sepoy10314303s_ep_oy
sepses84515883s_epses
sepsis83011293s_epsis
sermon8413553s_ermon
session739763s_ession
seton55223543s_e_ton
sexton133610793s_exton
shippon14285803shippon
siphon1138463s_iphon
skeps115614253skeps__
skepsis1344253skepsis
soupcon1144163soupcon
sponson935383sponson
spoon74719443s__poon
station72717243station
steapsins1144633steapsins
stearin7312003stearin
steepen9348653steepen
steeps85215193steeps__
stegodon1042473stegodon
stein54620543ste__in
stems75219953stems__
steno54716863ste_no_
stenos63915773ste_nos
stentor739383stentor
step67126293step___
steppe10319873step_pe
stepped123210053stepped
stepper113010853stepper
steppes113110693steppes
stepping13329073stepping
stepstool1162223stepstool
stereo65317913stereo_
stereos74314973stereos
stern55319123ste__rn
sternsons944663sternsons
sterol6613333ste_rol
stertor7310093stertor
stets55423913stets__
stewpan1234193stewpan
stews85519143stews__
stolon64112073st_olon
stops74827283stops__
streps86218063streps__
stressor875543stressor
stupor836013stup_or
stypsis1245243stypsis
syphon1436853s_yphon
teflon937453_teflon
telsons739223_telsons
tendon7312033_tendon
tenon53320513_te_non
tension7311803_tension
tensor63812673_tensor
tepoy10312163_tep_oy
teston6313303_teston
treason748763treason
typhon1436673_typhon
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.420425454.8
2DLD Change Limit134027887.19018640.8
3Display Results88880.0302933.3
 (SQL Overall)178691887.64023388.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.