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

120 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
tawse8561650(None) 
hawse116015121hawse
tasse54821841tasse
tawie84819811tawie
taws75641591taws_
tawsed10499741tawsed
tawses94913191tawses
apse67725382_apse
arse46539272_arse
awe67746622_aw_e
awee76336642_awee
awes76037552_awes
base64847022ba_se
bowse105420632bowse
carse74934332carse
case65848082ca_se
cause75225352cause
caws96036102caws_
daws86638242daws_
dowse96020812dowse
ease45042332ea_se
false84818122false
gawsie1038462gawsie
gawsy12459092gawsy
hanse85722792hanse
haws106439442haws_
hawser125910842hawser
hawses125113992hawses
jaws145027292jaws_
lapse74917682lapse
lase46148512la_se
laws76441682laws_
lowse87219902lowse
manse75528222manse
marse76231152marse
masse75125292masse
maws96437132maws_
owse76321622_owse
paise75028332paise
parse75236992parse
pase65346862pa_se
passe75525692passe
pause75021832pause
paws96038182paws_
raise54828052raise
rase46149982ra_se
raws75238212raws_
saws75839482saws_
tabes76033922tabes
table75429602table
tabs66842982tabs_
tace65342512ta_ce
taces76237802taces
tache106222372tache
tads57143942tads_
tae38267052ta__e
tags55545232tags_
tajes124920692tajes
take84739262ta_ke
takes94437792takes
tale46154162ta_le
tales55451372tales
tame66343662ta_me
tames75242012tames
tams67247932tams_
tans46154812tans_
tansy84514932tansy
taos45541002taos_
tape64538142ta_pe
tapes75838602tapes
taps66050672taps_
tare45957622ta_re
tares57456562tares
targe65227092targe
tarre55825632tarre
tars46763952tars_
tarsi55222172tarsi
tas38477102ta_s_
task85326652ta_sk
tass45640572ta_ss
tassel66014772tassel
tasses64826762tasses
tasset65925312tasset
tassie66017022tassie
taste55127232taste
tate44748602ta_te
tates55444982tates
tats46858132tats_
taupe7314162taupe
taus46342732taus_
tavs75630972tavs_
taw610155452taw__
tawed95926192tawed
tawer85223442tawer
tawney12338232tawney
tawny114713652tawny
tawpie11339142tawpie
taxes124730822taxes
taxwise1734252taxwise
tazze1339572tazze
tease55428712tease
tense55225842tense
terse55026822terse
tews76431642tews_
thaws116515462thaws_
these86519012these
those85218142those
torse55833332torse
touse55430672touse
towie85821872towie
tows78545552tows_
twae74719572t_wae
twaes86513662twaes
twas76824082twas_
twee76827082t_wee
valse85117522valse
vase75629652va_se
vaws105527322vaws_
waws106834902waws_
yaws105531212yaws_

Search took 2 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 Filter178691538000.0901985455.6
2DLD Change Limit538001201.73630990.8
3Display Results1201200.0304000.0
 (SQL Overall)1786911201.85696277.5
 
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.