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

113 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
sewars9401862(None) 
dewars105117071dewars
sears54744911se_ars
sewans95215901sewans
sewar85421091sewar_
sewers94719711sewers
sowars94318011sowars
swears94114071swears
bears75739042be_ars
beware11313712beware
bewares12313372bewares
cedars93312832cedars
dears65736882de_ars
debars94218042debars
denars74621432denars
dewans105215142dewans
dewar95817732dewar_
ears46356592_e_ars
escars83913132escars
eskars10357592eskars
ewers86018822_ewers
fears84829392fe_ars
feuars938652feuars
gears64628692ge_ars
hears86737372he_ars
hewers123715272hewers
jowars16369652jowars
kebars124112492kebars
lears55938732le_ars
nears55529422ne_ars
pears75138612pe_ars
psywars1533672psywars
rears54739652re_ars
rebars84019832rebars
reward106017632reward
rewards114813992rewards
rewarm115913482rewarm
rewarms12439592rewarms
rewears102911032rewears
sawers94620162sawers
scars75433532s_cars
seals54839692se_als
seams75731662se_ams
sear47353842se_ar_
seas45755272se_a_s
seats54844342se_ats
seawans10379942seawans
seaward1148172seaward
seawards1237202seawards
seaware1049622seaware
seawares1139332seawares
seaways13307512seaways
secpars1138412secpars
sedans74816092sedans
seders74420282seders
seers55136382se_ers
seggars9377782seggars
selahs9313212selahs
senary93716072senary
senors63620782senors
sepals85217372sepals
seracs84418572seracs
serais64326132serais
sers45746652se__rs
severs94121122severs
sewage10310732sewage
sewages1139752sewages
sewan85921292sewa_n
sewer84426212sewer_
sews75836022sew__s
shears93820902shears
shewers134312042shewers
shwas116415102shwa_s
simars84916932simars
sitars65417592sitars
sizars154812622sizars
skewers14498372skewers
smears84714432smears
soars54732512s_oars
sofars94712782sofars
sonars64818972sonars
sowans94215892sowans
sowar85821342sowar_
sowcars1236012sowcars
sowers94923442sowers
spars75431542s_pars
spears84019472spears
spewers124210652spewers
stars55836572s_tars
steward1138052steward
stewards1236382stewards
sugars7312422sugars
swabs105817272s_wabs
swags94921252s_wags
swans84625012s_wans
swaps104819202s_waps
sward94221462s_ward
swards105415132s_wards
sware85828212s_ware
swarf115324652s_warf
swarfs125612062s_warfs
swarm106218832s_warm
swarms116112172s_warms
swart86234642s_wart
swats85726862s_wats
sways115518462s_ways
swear85316852swear_
sweats94814612sweats
tears55436462te_ars
velars93913722velars
wars78659802__wars
wears86030302we_ars
years84527672ye_ars

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 Limit825511132.48333246.5
3Display Results1131130.0303766.7
 (SQL Overall)1786911132.63967711.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.