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

144 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
startup93496(None) 
startups1033891startups
stackup1533742stackup
standup1034352standup
start55642312start__
started84217322started
starter73817882starter
startle72511122startle
starts65423122start_s
startsy10536702startsy
statue66015322sta_tue
status65515212sta_tus
stirrup943002stirrup
stratum9318252stratum
stratus73011732stratus
cartop104213563_cartop
flareup1243173flareup
larrup835713_larrup
markup1436903_markup
sannup836563s_annup
santur6311273s_antur
sartor6313883s_artor
satrap86212553satr_ap
scaleup1134483scaleup
scarp95724103scar__p
scart76139773scart__
scarted104816123scarted
scarts85321493scart_s
scaup95515993sca__up
setup73915823s__etup
shakeup1632763shakeup
shapeup1443293shapeup
sharp104922533shar__p
sirup74014913s_ir_up
situp74414063s__itup
smart75834093smart__
smarted105012613smarted
smarten9348863smarten
smarter94113133smarter
smartie9310173smartie
smartly12497433smartly
smarts86218003smart_s
smarty115013793smart_y
smashup1443453smashup
spartan948333spartan
stackups1643313stackups
stacte82113913stact_e
stactes91914633stactes
stadium1038073stadium
stairstep1142103stairstep
staithe1037723staithe
stamp95217363sta__mp
standups1143963standups
stannum944643stannum
star48037763star___
starch113013203star_ch
starchy15286743starchy
stardom1037763stardom
stardust946093stardust
stare54440263star__e
stared75429873star_ed
starer64027363star_er
starers74522313starers
stares66038753star_es
starets73515923starets
staring84527053staring
stark95425623star__k
starker114114693starker
starkly14277033starkly
starlet71620123starlet
starlit71512913starlit
starred85013453starred
starry94911673star_ry
stars55836573star__s
starship1348143starship
starters83714773starters
starting93116173starting
startled9208563startled
startler8248793startler
startles82111963startles
starve94613743star_ve
starved114911573starved
starver104611993starver
starves104614553starves
stat47352693sta_t__
statal61613223sta_tal
state56237333sta_t_e
stated75427833sta_ted
stater64427563sta_ter
states64337083sta_tes
static83118683sta_tic
statin63921473sta_tin
stator64015483sta_tor
stats55933363sta_t_s
statued8459893sta_tued
statues74614903sta_tues
stature74410683sta_ture
statusy10455423sta_tusy
statute7419323sta_tute
sternum947733sternum
stertor7310093stertor
stickup1533853stickup
stirp76815503stir__p
stirrups1042603stirrups
stoup75517073st__oup
strap77925263st_r_ap
strata63616283strat_a
stratal72710603stratal
stratas73013583stratas
strath93216373strat_h
straths102711723straths
strati63518903strat_i
stratous8410703stratous
stratums10266813stratums
strep77120853st_r_ep
strip77524343st_r_ip
strop77422243st_r_op
stroud7310383st_roud
strum75619453st_r_um
strut56030733st_r_ut
struts65616803st_ruts
sturt56028963sturt__
sturts63915143sturt_s
swart86234643swart__
swarth126012083swart_h
swarths13537323swarths
swarthy16466373swarthy
swarty125812383swart_y
syrup103010963s_yr_up
takeup1234583_takeup
tarp66936423_tar__p
tarsus6310513_tarsus
tart47566183_tart__
tartan64217513_tartan
tartar63214753_tartar
tarted74923373_tarted
tarter64023563_tarter
tartly96014023_tartly
tarts57242023_tart_s
tartufe1064673_tartufe
tarty86328183_tart_y
tittup834203_tittup
turnup835093_turnup
warmup1335343_warmup

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 Limit1340271446.11021935.7
3Display Results1441440.0463130.4
 (SQL Overall)1786911446.56227231.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.