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 “stomas” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
stomas8481632(None) 
somas76030371s_omas
stoas55126021sto_as
stoma75918271stoma_
stomal85213311stomal
stomps105612831stomps
abomas101113582abomas
aromas81018612aromas
asthmas12117362asthmas
atmas75721012at_mas
atoms76817562atom_s
comas95833002_comas
myomas1338302myomas
nomas74726412_nomas
osteomas1045332osteomas
scotomas1256262scotomas
shamas113717942shamas
sigmas94111362sigmas
simas75727552s_imas
sobas74424252s_obas
socas74026182s_ocas
sodas64123542s_odas
sofas85320712s_ofas
sojas124716392s_ojas
soma65635292s_oma_
soman75024902s_oman
somans84619302s_omans
soms66239372s_om_s
soras55041012s_oras
soyas84520912s_oyas
stamps105614022stamps
steams84916902steams
stemmas11256972stemmas
stems75219952stem_s
stigmas10206642stigmas
stimes85920572stimes
stoa45425912sto_a_
stoae55024262sto_ae
stoai55417872sto_ai
stoat57135952sto_at
stoats65117482stoats
stobs75718232sto_bs
stocks124715632stocks
stoics8311112stoics
stokes104821792stokes
stoles63927672stoles
stomach1436032stomach
stomachs1544952stomachs
stomata938532stomata
stomate9313122stomate
stomates10313342stomates
stomp95616662stom_p
stones65130032stones
stooks105115372stooks
stools65117022stools
stoops85917892stoops
stopes84525892stopes
stops74827282sto_ps
storax1389782storax
stores65533662stores
storks106115952storks
storms85814632storms
stoss54316342sto_ss
stots54828552sto_ts
stotts64612862stotts
stoups85313272stoups
stours65015632stours
stouts65019002stouts
stoves93818922stoves
stowps115710582stowps
stows86622702sto_ws
stroma84313072stroma_
stromal93010592stromal
strumas9419832strumas
stumps104912282stumps
stums75320082stum_s
stupas83910882stupas
summas104313162summas
toeas55726422_toeas
togas67823002_togas
tolas54532772_tolas
toman75724052_toman
tomans85419132_tomans
tombs97818732_tombs
tomes76037382_tomes
toms68343492_tom_s
toras55540372_toras

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.1261418182.5
2DLD Change Limit82551872.25036689.3
3Display Results87870.0136692.3
 (SQL Overall)178691872.38974797.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.