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

146 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
stand6592328(None) 
sand55338461s_and
staid66722071staid
stands75118051stands
stane55933001stane
staned74824641staned
stang66424681stang
stank95823301stank
strand74514821strand
aland65526412aland
and47244162__and
band76740902_band
bland85320452bland
brand85124492brand
eland65820392eland
gland75217712gland
grand75122692grand
hand86833702_hand
island738532island
land56337302_land
rand55839562_rand
sad47459202s_a_d
said55742112s_aid
sands65228582s_ands
sandy94221132s_andy
sane45954332s_ane
saned65636272s_aned
sang55441222s_ang
sank85236822s_ank
sans45153352s_ans
sard55344242s_ard
satang75711562satang
sated66238532sated
scad75725762sca_d
scald84818122scald
scan65530452scan_
scans74625102scans
scant79735072scant
scend85516292scend
send55237292s_end
shad86230912sha_d
shandy134710032shandy
shank125422192shank
shard96125962shard
shend94719972shend
skald104210172skald
skank84415582skank
slang66324022slang
slank95822772slank
slant55238702slant
soland75115042soland
sound64420022sound
spaed85522272spaed
span65234662span_
spang84919732spang
spank115919572spank
spans74528732spans
spend85619332spend
stab67329932sta_b
stabs76221382stabs
stack114421692stack
stade64825302stade
staff113817712staff
stag57332002sta_g
stage65330192stage
staged84521562staged
stags66226742stags
stagy96618892stagy
staig65519632staig
stain55727932stain
stained84215342stained
stains64923652stains
stair54719932stair
stake95927532stake
staked114621942staked
stale55637102stale
staled74728102staled
stalk94518002stalk
stall54722352stall
stamp95217362stamp
stance84316912stance
stanch113812372stanch
standby1334422standby
standee83514512standee
stander84316162stander
standup1034352standup
stanes64933402stanes
stanged94113842stanged
stangs75018162stangs
stanks104917702stanks
stanol6310722stanol
stanza1537072stanza
staph104314652staph
star48037762sta_r
stare54440262stare
stared75429872stared
stark95425622stark
stars55836572stars
start55642312start
stash84916972stash
stat47352692sta_t
state56237332state
stated75427832stated
stats55933362stats
stave85324992stave
staved103918052staved
staw78627692sta_w
stay78333722sta_y
stayed104817272stayed
stays86022022stays
stead65520272stead
steed66024942steed
steno54716862steno
stent55634512stent
stied65723032stied
sting65330242sting
stink95122502stink
stint57037662stint
stone55431182stone
stoned75923142stoned
stony85818642stony
stood65517712stood
stound7399902stound
strands83711952strands
strang75718312strang
stud56220092st_ud
stun45623452stun_
stung65417152stung
stunk94616292stunk
stuns54719492stuns
stunt55328172stunt
styed95815482styed
swan76631312swan_
swang95519722swang
swank125318232swank
swans84625012swans
sward94221462sward
tad47959822_ta_d
tan37167562_tan_
tang56138662_tang
tank85134012_tank
tans46154812_tans
tend56433772_tend
upstand1045342upstand
viand9511072viand
wand85833872_wand

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.0961861364.6
2DLD Change Limit538001461.78030224.7
3Display Results1461460.0304866.7
 (SQL Overall)1786911461.90693751.8
 
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.