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

131 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
stratum931825(None) 
stratums10266801stratums
stratus73011731stratus
striatum1044471striatum
erratum944512erratum
scrotum1145132scrotum
startup934962startup
statue66015322st_atue
status65515212st_atus
strata63616282strat_a
stratal72710602stratal
stratas73013582stratas
strath93216372strat_h
straths102711722straths
strati63518902strat_i
stratous8410702stratous
strum75619452str__um
ageratum1143463ageratum
atrium8411823atr_ium
datum8310633__datum
estrum81810513estr__um
granum9310913_granum
pomatum1346393pomatum
sagum8512873s__agum
sanctum1145293sanctum
satem76021463s__atem
scram910621623scra__m
scratch1446013scratch
scrotums1243973scrotums
scrum95418203scr__um
scutum1036373s_cutum
septum1038003s_eptum
seriatim1049223seriatim
serum75223473ser__um
solanum946403solanum
solatium1067613solatium
sorghum1343513sorghum
sprat76635973sprat__
sprats85819933sprat_s
sputum1035943s_putum
stadium1038073stadium
stannum944643stannum
stardom1037763stardom
start55642313start__
started84217323started
starter73817883starter
startle72511123startle
starts65423123start_s
startsy10536703startsy
startups1033893startups
stat47352693st_at__
statal61613223st_atal
state56237333st_at_e
stated75427833st_ated
stater64427563st_ater
states64337083st_ates
static83118683st_atic
statin63921473st_atin
statism9412283st_atism
stator64015483st_ator
stats55933363st_at_s
statued8459893st_atued
statues74614903st_atues
stature74410683st_ature
statusy10455423st_atusy
statute7419323st_atute
steam76322933stea__m
sternum947733sternum
stewbum1442943stewbum
stibium1145843stibium
stickum1534823stickum
stoat57135953stoat__
stoats65117483stoat_s
strafe95215983stra_fe
strafed114413333strafed
strafer103912463strafer
strafes104516003strafes
strain64919573stra_in
strains74218153strains
strait64025893stra_it
straiten838613straiten
straiter8311783straiter
straitly1136563straitly
straits74916323straits
strake104017393stra_ke
straked125415343straked
strakes114218073strakes
strand74514823stra_nd
strands83711953strands
strang75718313stra_ng
strange85416343strange
strap77925263stra__p
strappy14205263strappy
straps87721783stra_ps
strass67117223stra_ss
stratagem1263933stratagem
strategy1244363strategy
stratify1445703stratify
straw813321293stra__w
strawed114813613strawed
straws98718673stra_ws
strawy1210312823stra_wy
stray88525573stra__y
strayed114513283strayed
strayer104312503strayer
strays96417933stra_ys
stream84717293str_eam
stretch1236413stretch
stretta737293stretta
strette7310763strette
stretti747913stretti
stretto737733stretto
striata7379953striat_a
striate74218953striat_e
striated93414153striated
striates83417083striates
strontium1144613strontium
stroud7310383str_oud
struma84313273str__uma
strums84716453str__ums
strut56030733str__ut
struts65616803strut_s
stum65526023s___tum
subatom1147053subatom
substratum1452693substratum
tectum10328603_tectum
tragus749233_tragus
tram67034553_tra__m
trauma838803_tra_uma
tritium969013_tritium
veratrum1344313veratrum

Search took 10 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.390458182.1
2DLD Change Limit1340271319.19014584.0
3Display Results1311310.0462847.8
 (SQL Overall)1786911319.62618563.4
 
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.