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

222 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
stirs5592162(None) 
sirs44338341s_irs
stairs65416331stairs
stars55836571stars
sties55132981sties
stir45723251stir_
stirk95717411stirk
stirks104914241stirks
stirp76815501stirp
stirps85011821stirps
airs46447432_airs
amirs75924922amirs
asters65631602asters
astir55517092astir_
bestirs9311132bestirs
coirs75221052coirs
emirs76116162emirs
esters64627732esters
fairs85825442fairs
firs76637722_firs
flirs85518932flirs
hairs86225172hairs
heirs85618562heirs
keirs95313682keirs
kirs85831752_kirs
lairs55425872lairs
mairs76228302mairs
mirs66940582_mirs
noirs55615462noirs
pairs75325832pairs
sabirs85414632sabirs
saids65328862saids
sails55738102sails
sains55639972sains
santirs7312962santirs
saris54544952saris
satins64930482satins
satire63218002satire
satires72617572satires
satis55633682sati_s
satyrs937962satyrs
scars75433532scars
sears54744912sears
seers55136382seers
seifs85019332seifs
seis45542392sei_s
sers45746652s_ers
shiers94921752shiers
shies86136552shies
shims104422552shims
shins85131042shins
ships105123772ships
shire84727132shire
shires95225572shires
shirk124817842shirk
shirks134814122shirks
shirr84716922shirr
shirrs94413172shirrs
shirt84533902shirt
shirts94918342shirts
shits84731172shits
shivs115018802shivs
shris84221452shris
shtiks13297832shtiks
sibs65933552s_ibs
sics65234102s_ics
sims65737182s_ims
sins46755282s_ins
sips65740112s_ips
sir35746682s_ir_
sire46150422s_ire
sires55945372s_ires
sis37360552s_i_s
sitars65417592sitars
sites56045432sites
sits45050212s_its
situs55019232situs
skids104615342skids
skiers104713702skiers
skies95026842skies
skims114517202skims
skins94723472skins
skips115616612skips
skirl96012922skirl
skirls10449822skirls
skirr94810552skirr
skirrs10448192skirrs
skirt95624672skirt
skirts104111502skirts
skis84825302ski_s
skits94721872skits
slims75423652slims
slips76023722slips
slits56128852slits
slurs54123372slurs
smirk116612752smirk
smirks124910122smirks
snibs75613762snibs
snips75818012snips
snits54124832snits
soars54732512soars
soils55327982soils
sours55230502sours
spars75431542spars
speirs85013232speirs
spics94123242spics
spiers84421742spiers
spies76037622spies
spiks114117472spiks
spins75327982spins
spire75828692spire
spires84628112spires
spirt75032952spirt
spirts85317132spirts
spiry105017352spiry
spits74429552spits
spivs105114242spivs
spurs74621522spurs
sris45434152sri_s
stabs76221382stabs
stags66226742stags
staigs75414812staigs
stains64923652stains
stair54719942stair_
star48037762star_
stare54440262stare
stares66038752stares
stark95425622stark
start55642312start
starts65423122starts
stats55933362stats
stays86022022stays
steers63820982steers
steins64818342steins
stems75219952stems
steps76619882steps
stere55328542stere
steres63929532steres
stern55319122stern
sterns64616762sterns
stets55423912stets
stews85519142stews
stich104117922stich
stichs114511652stichs
stick115121562stick
sticks125118612sticks
stied65723032stied
stiff114219242stiff
stiffs12389962stiffs
stile54931572stile
stiles64328772stiles
still54922082still
stills64118572stills
stilt54831982stilt
stilts67915312stilts
stime76521802stime
stimes85920572stimes
stimy105114742stimy
sting65330242sting
stings76220182stings
stink95122502stink
stinks105616832stinks
stint57037662stint
stints65119762stints
stipe76523372stipe
stipes84524052stipes
stirpes95011292stirpes
stivers103613542stivers
stoas55126022stoas
stobs75718232stobs
stoics8311112stoics
stops74827282stops
store56333812store
stores65533662stores
stork96819692stork
storks106115952storks
storm76520402storm
storms85814632storms
story86723032story
stoss54316342stoss
stots54828552stots
stours65015632stours
stows86622702stows
stria55723212stria
strip77524342strip
strips85719652strips
stubs75016072stubs
studs64415872studs
stums75320082stums
stuns54719492stuns
sturt56028962sturt
sturts63915142sturts
styes86316522styes
suers55128482suers
suits55028052suits
swigs96213662swigs
swims105514142swims
swirl84514142swirl
swirls94010132swirls
swiss86712902swiss
tars46763952_tars
tics65729642_tics
tiers55526522_tiers
ties45248322_ties
tils45739622_tils
tins45251312_tins
tips66436772_tips
tire46143362_tire
tires55437492_tires
tirl45029932_tirl
tirls54519802_tirls
tiro46832372_tiro
tiros54524892_tiros
tis37056652_ti_s
tits46145052_tits
tors46157382_tors
tsars56717112tsars
upstirs935292upstirs
vairs85019132vairs
wairs86424062wairs
weirs84316492weirs
whirs115218092whirs

Search took 8 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 Filter178691538001.593112172.6
2DLD Change Limit538002225.36010037.3
3Display Results2222220.0762921.1
 (SQL Overall)1786912227.02925422.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.