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

111 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
startups103389(None) 
startup934961startup_
stackups1643312stackups
standups1143962standups
starters83714782starters
startles82111962startles
starts65423122start__s
statues74614902sta_tues
status65515212sta_tu_s
stirrups1042602stirrups
stratums10266812stratums
stratus73011732stratu_s
flareups1342473flareups
larrups934733_larrups
markups1534963_markups
sannups934463s_annups
santurs7310763s_anturs
sartors7314973s_artors
satraps95011643satr_aps
scaleups1243393scaleups
scarps104718603scar__ps
scarts85321493scart__s
scaups105411933sca__ups
setups83910463s__etups
shakeups1742373shakeups
shapeups1542723shapeups
sharps115516083shar__ps
sirups83710533s_ir_ups
situps8538783s__itups
smartass1044273smartass
smartens10286663smartens
smarties10312873smarties
smarts86218003smart__s
smashups1543213smashups
stackup1533743stackup_
stactes91914633stact_es
stadiums1145703stadiums
stairsteps1251733stairsteps
staithes1138953staithes
stamps105614023sta__mps
standup1034353standup_
stannums1043803stannums
starburst1143493starburst
starches131912913starches
stardoms1136793stardoms
stardust946093stardust
stardusts1043153stardusts
starers74522313star_ers
stares66038753star__es
starets73515923star_ets
starkers123712393starkers
starless81610843starless
starlets81610083starlets
stars55836573star___s
starships1447663starships
start55642313start___
started84217323start_ed
starter73817883start_er
starting93116173starting
startle72511123start_le
startled9208563startled
startler8248793startler
startlers9236743startlers
startsy10536703start_sy
starvers11459643starvers
starves104614553star_ves
staters73922343sta_ters
states64337083sta_t_es
statics93314533sta_tics
statins73719773sta_tins
stators73915583sta_tors
stats55933363sta_t__s
statue66015323sta_tu_e
statued8459893sta_tued
stature74410683sta_ture
statures83711113sta_tures
statuses8409543sta_tuses
statusy10455423sta_tusy
statute7419323sta_tute
statutes8368893sta_tutes
sternums1045783sternums
stertors8310933stertors
stickups1643303stickups
stirps85011823stir__ps
stirrup943003stirrup_
stoups85313273st__oups
straps87721783st_r_aps
stratas73013583strat_as
straths102711723strat_hs
stratous8410703stratous
stratum9318253stratu_m
streps86218063st_r_eps
strips85719653st_r_ips
strops86220383st_r_ops
strouds837803st_rouds
strums84716453st_r_ums
struts65616803st_r_uts
sturts63915143sturt__s
swarths13537323swart_hs
syrups11277953s_yr_ups
takeups1333403_takeups
tarps76527123_tar__ps
tarsus6310513_tarsu_s
tartans72615823_tartans
tartars73313403_tartars
tarts57242023_tart__s
tartufe1064673_tartufe
tartufes1164153_tartufes
tittups933353_tittups
turnups933893_turnups
warmups1433813_warmups

Search took 9 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.436409841.7
2DLD Change Limit1461621117.67319048.9
3Display Results1111110.0462413.0
 (SQL Overall)1786911118.15521911.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.