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

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

185 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
start5564231(None) 
scart76139771scart
smart75834091smart
star48037761star_
stare54440261stare
stark95425621stark
stars55836571stars
starts65423121starts
stat47352691sta_t
sturt56028961sturt
swart86234641swart
tart47566181_tart
apart74330672apart
art38679142__art
boart78835932boart
cart66570342_cart
chart105038282chart
dart55857872_dart
fart76860562_fart
hart76865772_hart
heart85440742heart
kart86750802_kart
lyart85121882lyart
mart66865982_mart
part65967462_part
peart76440752peart
quart144027852quart
restart7320032restart
salt45758522s_alt
sard55344242s_ard
sari45444042s_ari
sark84938972s_ark
sat36288482s_a_t
satara6315532satara
scant79735072scant
scar66434202scar_
scare75334462scare
scarf105427142scarf
scarp95724102scarp
scars75433532scars
scarts85321492scarts
scary105222592scary
scat65848372sca_t
scatt76030092scatt
sear47353842sear_
sears54744912sears
seat47575562sea_t
shaft115725272shaft
shalt85534492shalt
shard96125962shard
share86437082share
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shat76456602sha_t
shirt84533902shirt
short85040532short
sitar54820542sitar_
sitars65417592sitars
skat87037902ska_t
skirt95624662skirt
skort94925642skort
slant55238702slant
slat46959022sla_t
smalt74729332smalt
smarm95517602smarm
smarts86218002smarts
smarty115013792smarty
snare54429982snare
snarf86525422snarf
snark95419942snark
snarl54921082snarl
snort54833752snort
soar46838672soar_
soars54732512soars
sort46264812s_ort
spait75631602spait
spar65433302spar_
spare75135562spare
spark114920892spark
spars75431542spars
spat66548522spa_t
spirt75032952spirt
sport75935982sport
sprat76635972sprat
spurt77227982spurt
stab67329932sta_b
stabs76221382stabs
stack114421692stack
stacte82113912stacte
stade64825302stade
staff113817712staff
stag57332002sta_g
stage65330192stage
stags66226742stags
stagy96618892stagy
staid66722082staid
staig65519642staig
stain55727942stain
stair54719942stair
stairs65416332stairs
stake95927532stake
stale55637102stale
stalk94518002stalk
stall54722352stall
stamp95217362stamp
stand65923282stand
stane55933002stane
stang66424682stang
stank95823302stank
staph104314652staph
starch113013202starch
stared75429872stared
starer64027362starer
stares66038752stares
starets73515922starets
starlet71620122starlet
starlit71512912starlit
starry94911672starry
started84217322started
starter73817882starter
startle72511122startle
startsy10536702startsy
startup934962startup
starve94613742starve
stash84916972stash
state56237332state
stats55933362stats
stave85324992stave
staw78627692sta_w
stay78333722sta_y
stays86022022stays
stent55634512stent
stere55328542stere
stern55319122stern
stet45947322st_et
stilt54831982stilt
stint57037662stint
stir45723252stir_
stirk95717412stirk
stirp76815502stirp
stirs55921622stirs
stoat57135952stoat
stopt76528352stopt
store56333812store
stork96819692stork
storm76520402storm
story86723032story
stot46347332st_ot
stott56929792stott
stout57434052stout
strait64025892strait
strap77925262strap
strata63616282strata
strath93216372strath
strati63518902strati
straw813321292straw
stray88525572stray
strut56030732strut
stunt55328172stunt
sturts63915142sturts
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218842swarm
swarth126012082swarth
swarty125812382swarty
swat77244442swa_t
tact67349032_tact
tar37570692_tar_
tare45957622_tare
tarn46842722_tarn
taro46846912_taro
tarot55943932_tarot
tarp66936412_tarp
tars46763952_tars
tarts57242022_tarts
tarty86328182_tarty
tat37690292_ta_t
taut47048962_taut
tort46967462_tort
tsar47819802tsar_
tsars56717112tsars
upstart9159752upstart
wart77866082_wart

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit538001851.73630990.8
3Display Results1851850.0632936.5
 (SQL Overall)1786911852.10984727.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.