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

196 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
stied6572303(None) 
shied96125491shied
sited65130741sited
skied104417751skied
spied85427711spied
steed66024941steed
sties55132981sties
stiped94517071stiped
styed95815481styed
tied55535211_tied
cited84421952cited
citied94014142citied
cried84624282cried
died66137852_died
dried75321382dried
espied9359772espied
flied96519432flied
fried95322912fried
gied64631982_gied
hied85434042_hied
ivied94710512ivied
kited105120092kited
lied55838092_lied
pied75035362_pied
pitied94017252pitied
plied85118592plied
pried84426862pried
retied75924982retied
sabed86526812sabed
said55742112sai_d
sailed74327762sailed
sained75424242sained
saned65636272saned
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scried95817302scried
seed55549482s_eed
seined74023062seined
seised74218122seised
seized164313652seized
sered65737292sered
sewed95325162sewed
sexed136618542sexed
shed86536152s_hed
shiel811023772shiel
shield106212972shield
shier85428942shier
shies86136552shies
shined104620782shined
shoed95723002shoed
shred98125612shred
side55444482s_ide
sided74825952sided
sild55030582s_ild
siped84927682siped
sired66134282sired
site47052412site_
sites56045432sites
sized155519242sized
skeed105018982skeed
skid95720912ski_d
skier95119592skier
skies95026832skies
skiey125012892skiey
skited114313472skited
skived14429892skived
skyed13529922skyed
sled55334372s_led
sliced94416312sliced
slid55828982sli_d
slide64725412slide
slier54827242slier
slimed94915122slimed
sliped95417062sliped
slued64220512slued
smiled93716432smiled
sned56026052s_ned
snide64318722snide
sniped94913482sniped
soiled73822472soiled
soled65835172soled
sored66141782sored
sortied83314092sortied
sotted74121392sotted
sowed94933862sowed
spaed85522272spaed
sped76031492s_ped
speed85526622speed
spiced115218312spiced
spiel74623912spiel
spier75728032spier
spies76037622spies
spiked134915552spiked
spiled94621992spiled
spined95423942spined
spired94921862spired
spited94820442spited
spued84918472spued
stade64825302stade
staged84521562staged
staid66722072staid
stained84215342stained
staked114621942staked
staled74728102staled
stand65923282stand
staned74824642staned
stared75429872stared
stated75427832stated
staved103918052staved
stayed104817272stayed
stead65520272stead
steeds73814882steeds
steek95418002steek
steel55721992steel
steep76020702steep
steer55423862steer
stein54620532stein
stem610628242st_em
step67126292st_ep
stet45947322st_et
stew77525462st_ew
stewed104814242stewed
stey76224412st_ey
stich104117922stich
stick115121562stick
sticked144114632sticked
stiff114219232stiff
stiffed14359582stiffed
stifled113511092stifled
stile54931572stile
stiles64328762stiles
still54922072still
stilled83314772stilled
stilt54831982stilt
stilted83511472stilted
stime76521792stime
stimes85920572stimes
stimied10310612stimied
stimy105114732stimy
sting65330242sting
stink95122502stink
stint57037662stint
stinted82914192stinted
stipe76523372stipe
stipel84412122stipel
stipend10386552stipend
stipes84524052stipes
stir45723242sti_r
stirk95717412stirk
stirp76815502stirp
stirred8359692stirred
stirs55921612stirs
stiver93915732stiver
stoked114718292stoked
stoled74521592stoled
stoned75923142stoned
stood65517712stood
stoped94721012stoped
stored75524212stored
storied8515162storied
stowed105817202stowed
strep77120852strep
strew89220652strew
stride75420962stride
striped105214362striped
strived114713662strived
stud56220092st_ud
studied9268692studied
stye76218972stye_
styes86316522styes
styled105613102styled
stymied1335652stymied
sued56537932s_ued
suited74019422suited
swiped123811092swiped
swived133610632swived
ted46446562_t_ed
teed55439262_teed
tide55237372_tide
tided76322512_tided
tie36557532_tie_
tier44936142_tier
ties45248312_ties
tiled64832942_tiled
timed85223612_timed
tined65434532_tined
tired65228902_tired
toed56137042_toed
tried65026912tried
tsked105910032tsked
untied73720812untied
vied86328632_vied
wited94727142wited
wried95518562wried

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.0762351197.4
2DLD Change Limit538001961.95327547.4
3Display Results1961960.0633111.1
 (SQL Overall)1786911962.09285416.3
 
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.