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

162 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
stains6492365(None) 
sains55639971s_ains
satins64930481satins
staigs75414811staigs
stain55727941stain_
stairs65416331stairs
statins73719771statins
steins64818341steins
strains74218151strains
swains94513951swains
tains54936321_tains
abstains1047322abstains
ains46158882__ains
attains7310982attains
blains84516372blains
brains85125472brains
cains75334302_cains
chains114819702chains
destains9311812destains
detains83716092detains
distains9413602distains
drains73719402drains
elains64919852elains
estrins7315852estrins
etamins91511832etamins
gains65729512_gains
grains74223092grains
isatins7310772isatins
kains96125642_kains
mains75635112_mains
matins84527782matins
obtains939162obtains
pains75138282_pains
patins87528782patins
plains85019592plains
rains55140232_rains
retains74522252retains
sabins85521982sabins
saids65328852s_aids
sails55738102s_ails
sain45551292s_ain_
saint55147072s_aint
saints65122422s_aints
sans45153362s_a_ns
sarins63932622sarins
sasins64923102sasins
satin55935222satin_
sating74735452sating
satiny93817982satiny
satis55633682sati_s
savins93923132savins
scans74625102sca_ns
serins64029672serins
sextains15246812sextains
shairns10276782shairns
sharns95516982sharns
shins85131042s_hins
sins46755272s__ins
skeins103911902skeins
skins94723462s_kins
slain54923572slain_
snails64816652snails
sozins15510792sozins
spails84817822spails
spaits85017472spaits
spans74528732spa_ns
spavins12419322spavins
spawns11577922spawns
spins75327982s_pins
sprains93013592sprains
stabs76221382sta_bs
stacks124317262stacks
stades74626242stades
stadias8411112stadias
staffs12349752staffs
stages75629492stages
staging93818372staging
stagings10378342stagings
stags66226742sta_gs
staid66722082stai_d
staig65519642stai_g
stained84215342stained
stainer73614922stainer
stainers83212172stainers
stair54719942stai_r
stakes103927292stakes
staking123919802staking
stales65538292stales
staling83925422staling
stalks104614552stalks
stalls64019932stalls
stamens93411482stamens
stamina9310792stamina
staminas1048852staminas
stamps105614022stamps
stand65923282sta_nd
stands75118052stands
stane55933002sta_ne
stanes64933402stanes
stang66424682sta_ng
stangs75018162stangs
stanine73417072stanine
stanines85115672stanines
staning83922242staning
stank95823302sta_nk
stanks104917702stanks
stapes85028732stapes
staphs114411032staphs
stares66038752stares
staring84527052staring
stars55836572sta_rs
starts65423122starts
stases64225562stases
stasis63116872stasis
states64337082states
statics93314532statics
statin63921472statin_
stating83725162stating
stations82415222stations
stats55933362sta_ts
status65515212status
staves94525192staves
staving113915702staving
staying114017322staying
stays86022022sta_ys
stearins8312142stearins
stein54620542stein_
sterns64616762sterns
sties55132982st_ies
sting65330242st_ing
stings76220182st_ings
stink95122502st_ink
stinks105616832st_inks
stint57037662st_int
stints65119762st_ints
stirs55921622st_irs
stoics8311112stoics
stotins73213872stotins
strain64919572strain_
straits74916322straits
string75327562string
strings84617132strings
strips85719652strips
stuns54719492st_uns
stying105414572stying
sustains838552sustains
swails94913122swails
swain84919052swain_
swans84625012swa_ns
tails55634192_tails
tain45548072_tain_
taint55542282_taint
taints64520532_taints
takins105117402_takins
tans46154822_ta_ns
tarns56433952_tarns
thins85826332_thins
tins45251302_t_ins
trains64725342trains
twains95811182twains
twins85118982_twins
wains86930872_wains

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.343520965.0
2DLD Change Limit825511622.23336968.7
3Display Results1621620.0463521.7
 (SQL Overall)1786911622.62268150.6
 
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.