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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

138 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
steepen9348652steepen
steppe10319872steppe_
stepped123210052stepped
stepper113010852stepper
steppes113110692steppes
stepson945672stepson
beechen14367703beechen
deepen9339193deep_en
ethephon1643473ethephon
freshen133010883freshen
greyhen1443193greyhen
hyphen1736393_hyphen
keppen14346573_keppen
nephew1434113_nephew
peahen113410133_peahen
saphena1235863s_aphena
sateen63815013sate__en
scepter1138363scepter
seamen84518563s_eamen
seedmen1037683seedmen
seen46943123s_e__en
seeped94317523seep_ed
seepier92912013seepier
seethe93712483seethe_
seethed113410193seethed
seethes103613743seethes
semen75724103s_e_men
sepses84515883s_epses
septet8921133s_eptet
seven84118313s_e_ven
shapen114414653shap_en
shebeen1234553shebeen
sheen85023313she__en
sheepmen1544643sheepmen
shepherd1744373shepherd
shipmen14317283shipmen
shippen14298863shippen
shopmen14277203shopmen
siphon1138463s_iphon
skeen94817403ske__en
sleeken11326803sleeken
somewhen1642283somewhen
sphene113412403s__phene
stamen84115943st_amen
stapes85028733stap_es
staph104314653staph__
staphs114411033staph_s
staple84415823staple_
stapled103613703stapled
stapler93913633stapler
staples93617213staples
stashed113812493stashed
stashes103916173stashes
steaded92811673steaded
stealer72913983stealer
steamed103712143steamed
steamer93313093steamer
steapsin1044713steapsin
stearin7312003stearin
steed66024943ste__ed
steek95418003ste__ek
steeked124010473steeked
steel55721993ste__el
steeled83513223steeled
steep76020703ste__ep
steeped103412283steeped
steepens10277113steepens
steeper93812773steeper
steeple937323steeple_
steepled1135903steepled
steeples1038013steeples
steer55423863ste__er
steered83615253steered
steerer73113633steerer
steeve93710903steeve_
steeved113610133steeved
steeves103410903steeves
stein54620543ste__in
stelae63716483stelae_
stele55026843ste_le_
stelene7310253ste_lene
steles63725663ste_les
stemmed12278153stemmed
stemmer113210183stemmer
stemson945163stemson
stenches132110293stenches
step67126293step___
steppers12289283steppers
stepping13329073stepping
steps76619883step__s
stepsons1045663stepsons
stere55328543ste_re_
stereo65317913ste_reo
steres63929533ste_res
sterlet71318473sterlet
stern55319123ste__rn
sterner7411913sterner
stetson745783stetson
stetted82610403stetted
stewed104814243ste_wed
stewpan1234193stewpan
stiffen13286023stiffen
stipe76523373stip_e_
stiped94517073stip_ed
stipel84412123stip_el
stipend10386553stip_end
stipes84524053stip_es
stolen64315063st_olen
stollen747593stollen
stope74727243stop_e_
stoped94721013stop_ed
stoper84320103stop_er
stopes84525893stop_es
stopped124512203stopped
stopper113012603stopper
stouten7307333stouten
striven103910753striven
strophe1239143strophe_
strophes13310603strophes
stupe75217753stup_e_
stupes84116953stup_es
sweeten10267313sweeten
sweven1235983swe_ven
sypher14317083s_ypher
syphon1436853s_yphon
teched124014433_teched
teen45938203_te__en
tegmen988403_tegmen
telpher1235563_telpher
tepee74724213_tep_ee
tepees84215243_tepees
tephra1136483_tephra
tether93716103_tether
then78429693_t__hen
tophe106718973_tophe_
tophes115218423_tophes
typhon1436673_typhon
waterhen1485313waterhen

Search took 7 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.406440125.6
2DLD Change Limit1340271385.96622465.1
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.41827842.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.