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

135 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
stalk9451800(None) 
stack114421691stack
stale55637101stale
stalks104614551stalks
stalky13499301stalky
stall54722351stall
stank95823301stank
stark95425621stark
talk86230091_talk
balk105132222_balk
bytalk1533472bytalk
calk105527662_calk
chalk144814602chalk
sack105337312s_ack
sal36462882s_al_
sale44959702s_ale
sall44544682s_all
salp64534092s_alp
sals46851672s_als
salt45758522s_alt
sank85236822s_ank
sark84938972s_ark
scald84818122scald
scale74629142scale
scall74420372scall
scalp95217982scalp
scaly104718722scaly
sculk115112462sculk
seal45654372seal_
seals54839692seals
setal56430902setal_
shack145321752shack
shale85332832shale
shall85024052shall
shalt85534482shalt
shaly114322862shaly
shank125422192shank
shark126225022shark
sial45938832sial_
sials54227242sials
silk85529322s_ilk
skald104210172skald
skank84415582skank
skulk8479622skulk
slack115021762slack
slank95822772slank
smack134615452smack
small74016262small
smalt74729332smalt
snack114718062snack
snark95419942snark
soak87227662soa_k
spale74929212spale
spall74919302spall
spank115919572spank
spark114920892spark
stab67329932sta_b
stable83921642stable
stably113314122stably
stabs76221382stabs
stacks124317262stacks
stade64825302stade
staff113817712staff
stag57332002sta_g
stage65330192stage
stags66226742stags
stagy96618892stagy
staid66722072staid
staig65519632staig
stain55727932stain
stair54719932stair
stake95927532stake
stalag7310022stalag
staled74728102staled
staler64025822staler
stales65538292stales
stalked123811172stalked
stalker113912252stalker
stalls64019922stalls
stamp95217362stamp
stand65923282stand
stane55933002stane
stang66424682stang
stanks104917702stanks
staph104314652staph
staple84415822staple
star48037762sta_r
stare54440262stare
stars55836572stars
start55642312start
stash84916972stash
stat47352692sta_t
state56237332state
stats55933362stats
stave85324992stave
staw78627692sta_w
stay78333722sta_y
stays86022022stays
steak95219802steak
steal56125472steal_
steals64020062steals
steek95418002steek
stela54019042stela
stele55026842stele
stick115121562stick
stile54931572stile
still54922072still
stilt54831982stilt
stink95122502stink
stirk95717412stirk
stock114417562stock
stole54928812stole
stook95218212stook
stork96819692stork
stuck114515772stuck
stull54916272stull
stunk94616292stunk
style85519362style
styli83911172styli
sulk85326652s_ulk
swale85221592swale
swank125318232swank
tack106536292_tack
tala45938052_tala
talc66226812_talc
tale46154162_tale
tali46837162_tali
talks94322692_talks
talky126215682_talky
tall47240212_tall
taluk94812872_taluk
tank85134012_tank
task85326652_task
uptalk1234652uptalk
walk115625612_walk

Search took 2 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.0931921408.6
2DLD Change Limit538001351.70331591.3
3Display Results1351350.0462934.8
 (SQL Overall)1786911351.84297009.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.