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

151 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
stimes8592057(None) 
slimes84722041slimes
sties55132981sti_es
stiles64328761stiles
stime76521791stime_
stimies9316551stimies
stipes84524051stipes
times75630821_times
animes84719592animes
betimes115114412betimes
chimes134922572chimes
climes104720002climes
crimes105521582crimes
dimes85833042_dimes
glimes94717522glimes
grimes94619032grimes
limes75636502_limes
mimes95732022_mimes
mistimes12612612mistimes
optimes1148462optimes
oximes15107422oximes
pastimes123611902pastimes
primes104225262primes
retimes95020172retimes
rimes75634542_rimes
saices84221802saices
satires72617572satires
seines65029902seines
seises64026712seises
seizes154317532seizes
semes75731582s_emes
septimes1238292septimes
shames114726222shames
shies86136552shi_es
shims104422542shim_s
shines95028912shines
shires95225572shires
shives124921412shives
sices75637272s_ices
sides65838362s_ides
sikes96236082s_ikes
simas75727552s_imas
simps94719762s_imps
sims65737172s_im_s
sines55954822s_ines
sipes76036952s_ipes
sires55945372s_ires
sises55233832s_ises
sites56045432s_ites
sixes124526362s_ixes
sizes146727762s_izes
skies95026832ski_es
skimos12548802skimos
skimps14488042skimps
skims114517182skim_s
skites104418032skites
skives134113942skives
slices84022852slices
slides73922182slides
slime74925752slime_
slimed94915122slimed
slims75423652slim_s
slipes84921412slipes
smiles84522292smiles
smites83921922smites
snipes83917392snipes
spices104326032spices
spies76037622spi_es
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spites84127332spites
spumes1021314882spumes
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stamen84115942stamen
stamens93411482stamens
stamps105614022stamps
stanes64933402stanes
stapes85028732stapes
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
steles63725662steles
stems75219952stem_s
steres63929532steres
stichs114511652stichs
sticks125118612sticks
stied65723032sti_ed
stiffs12389962stiffs
stifles103013382stifles
stigmas10206632stigmas
stile54931572stile_
stills64118562stills
stilts67915302stilts
stimied10310612stimied
stimy105114732stim_y
stings76220182stings
stinks105616832stinks
stints65119762stints
stipe76523372stipe_
stiped94517072stiped
stipel84412122stipel
stipels9418952stipels
stirks104914232stirks
stirpes95011292stirpes
stirps85011812stirps
stirs55921612sti_rs
stiver93915732stiver
stivers103613532stivers
stokes104821792stokes
stoles63927672stoles
stomas84816322stomas
stomps105612832stomps
stones65130032stones
stopes84525892stopes
stores65533642stores
stoves93818922stoves
strides84520392strides
strifes104716582strifes
strikes114719092strikes
stripes95320572stripes
strives104119372strives
stumps104912282stumps
stums75320082stum_s
stupes84116952stupes
styes86316522st_yes
styles94418652styles
stymies1239212stymies
suites63727402suites
swims105514142swim_s
swipes114114332swipes
swives123915182swives
tames75242012_tames
tides64830152_tides
ties45248312_ti_es
tikes95628902_tikes
tiles55542102_tiles
time66235012_time_
timed85223612_timed
timer75626042_timer
timers84420992_timers
tines54848422_tines
tires55437492_tires
tomes76037382_tomes
tsimmes1133672tsimmes
uptimes1177542uptimes

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.1231452772.4
2DLD Change Limit825511512.78329662.6
3Display Results1511510.0305033.3
 (SQL Overall)1786911512.93660862.1
 
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.