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

121 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
storks10611595(None) 
stirks104914241stirks
stocks124715631stocks
stooks105115371stooks
stores65533661stores
stork96819691stork_
storms85814631storms
borks115727702_borks
corks116028272_corks
dorks105724442_dorks
forks125324682_forks
porks115124142_porks
sarks96632462s_arks
satoris7317252satoris
scores84725922scores
scorns85713022scorns
sharks135019722sharks
shirks134814122shirks
shocks154414582shocks
shooks134515632shooks
shores94830412shores
shorls94516202shorls
shorts95321742shorts
skorts104211302skorts
smerks12449712smerks
smirks124910122smirks
smocks145710012smocks
snarks104815732snarks
snooks104412832snooks
snores64324322snores
snorts64116502snorts
soaks95220292s_oaks
socks114926082s_ocks
sooks94425452s_ooks
soras55041012s_oras
sorbs75022102s_orbs
sords64527802s_ords
sores55454282s_ores
sorns55028422s_orns
sorts54536662s_orts
sorus54527582s_orus
souks94820522s_ouks
sparks124616362sparks
spooks124312932spooks
spores84726612spores
sports84619182sports
stacks124317262stacks
stalks104614552stalks
stanks104917702stanks
stares66038752stares
stark95425622stark_
stars55836572star_s
starts65423122starts
steaks104415852steaks
steeks103613702steeks
steres63929532steres
sterns64616762sterns
sticks125118612sticks
stinks105616832stinks
stirk95717412stirk_
stirps85011822stirps
stirs55921622stir_s
stoas55126022sto_as
stoats65117482stoats
stobs75718232sto_bs
stock114417562stock_
stocky15369152stocky
stoics8311112stoics
stoke94922512sto_ke
stokes104821792stokes
stoles63927672stoles
stomas84816322stomas
stomps105612832stomps
stones65130032stones
stook95218212stook_
stools65117022stools
stoops85917892stoops
stopes84525892stopes
stops74827282sto_ps
storax1389782storax
store56333812stor_e
stored75524212stored
storer64721672storer
storers75018682storers
storey95217612storey
storeys10559652storeys
stories7324272stories
storm76520402stor_m
stormy115510732stormy
story86723032stor_y
stoss54316342sto_ss
stots54828552sto_ts
stotts64612862stotts
stoups85313272stoups
stoures74614162stoures
stours65015632stours
stouts65019002stouts
stoves93818922stoves
stowps115710582stowps
stows86622702sto_ws
stroke105116172stroke
strokes114316322strokes
strops86220382strops
strows96718272strows
stroys95914602stroys
sturts63915142sturts
swords104510802swords
toras55540372_toras
torcs75123762_torcs
tores55352672_tores
toros54336192_toros
torrs53923562_torrs
tors46157382_tor_s
torsk94915772_torsk
torsks10549122_torsks
torts56138122_torts
torus54329762_torus
tsores65113662tsores
tsoris63411192tsoris
turks95320822_turks
works125621902_works

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 Filter178691825510.360496363.9
2DLD Change Limit825511212.26636430.3
3Display Results1211210.0462630.4
 (SQL Overall)1786911212.67266875.4
 
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.