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

123 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
substate10171109(None) 
substage11117181substage
substates111410331substates
substrate11178791substrate
outstate81411992outstate
sublate9315362sub_late
subovate1347332subovate
subsale9310542subs_ale
subscale1247602subscale
subsite9412872subs_ite
subspace1445682subspace
substages12127352substages
substance1346742substance
substrata11184912substrata
substrates12168552substrates
subulate10312742subulate
unstate71916212_unstate
upstate91610492_upstate
apostate1049853apostate
aristate8312133aristate
bistate9313823_bistate
bursate94111203burs_ate
costate94019273_costate
cristate10310603cristate
curtate9312643cu_rtate
cuspate1138233cu_spate
estate64719763__estate
gestate83614073_gestate
grubstake1651623grubstake
guttate8328903gu_ttate
hastate10313913_hastate
hebetate1347053hebetate
instate71616483_instate
jubilate1746553jubilate
lustrate8310443lu_strate
misstate10711343misstate
mutate83017483mu__tate
nutate63017373nu__tate
outate62923403ou__tate
outskate12168013outskate
outstare81410693outstare
outstated10169813outstated
outstates91710753outstates
prostate10314533prostate
pulsate9510233puls_ate
punctate1246473punctate
restate73824883_restate
sabotage1144603sabotage
sanitate8612043sanitate
scutate9310323s_cutate
sensate7311883sens_ate
septate9511873s_eptate
sibilate1049533sibilate
spectate12248833spectate
state56237333___state
subacute1245753subacute
subbase1139323sub_base
subcaste1287853subcaste
subframe1546333subframe
subgrade1246053subgrade
subjugate1943553subjugate
sublated11311503sub_lated
sublates10315003sub_lates
sublease1038383sublease
sublimate1347433sublimate
subphase1555603subphase
subrace11313003sub_race
subrogate1246043subrogate
subsales10310123subs_ales
subscales1347343subscales
subsea82610193subsea__
subsect112611843subsect_
subsects12267903subsects
subsense1046963subsense
subsere9311443subs_ere
subserve1346463subserve
subset83122583subs_et_
subsets92813103subs_ets
subshaft1645173subshaft
subshafts1743093subshafts
subside10410453subs_ide
subsist9311573subsist_
subsisted1245783subsisted
subsister1145983subsister
subsists1037993subsists
subsites10312783subs_ites
subspaces1545673subspaces
substances1446323substances
substantive1654173substantive
substation1248993substation
substitute1254623substitute
substratum1452693substratum
subsume1146713subs_ume
subsystem1652393subsystem
subtask1335713sub_task
subtaxa1644483sub_taxa
subtile91912623sub_tile
subtitle1046603sub_title
subtle82113433sub_t_le
subtone9310343sub_tone
subtype1444203sub_type
sufflate1456183sufflate
sulcate9314423su_lcate
sulfate10311653su_lfate
sulphate1346643sulphate
summate113611663su_mmate
sunshade1244353sunshade
sunstone847793sunstone
superstate1249833superstate
supinate10310313supinate
suricate10312613suricate
sustain738773su_stain
testate73916233_testate
tristate8311033tristate
tubate82813173tub__ate
tubulate1038273tubulate
tungstate1042873tungstate
unstated91615813_unstated
unstates81314993_unstates
upstage10167443_upstage
upstare9158683_upstare
upstater10156663_upstater
upstates10189643_upstates

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621237.29620033.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.49823831.8
 
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.