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

132 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
tacet7584002(None) 
facet106038521facet
tace65342511tace_
taces76237801taces
tacit76333671tacit
tacket124627491tacket
tact67349031tac_t
abet610547942_abet
ace59656832_ace_
aced79540882_aced
aces67645092_aces
aceta74017352_aceta
act59557842_ac_t
cachet134526412cachet
cadet85339342cadet
caret75360562caret
dace76934922dace_
daces85030682daces
face96140122face_
faced117727652faced
facer105525052facer
faces106439432faces
facete115014832facete
facets116316652facets
fact97142542fac_t
faucet115816552faucet
hacek145411842hacek
haet75659502ha_et
jacket194720672jacket
lace66848472lace_
laced87132642laced
lacer75833752lacer
laces76141762laces
lacey105820912lacey
lancet84223572lancet
mace87345792mace_
maced108528692maced
macer912126942macer
maces97139962maces
oncet74626542oncet
pace86345772pace_
paced106931682paced
pacer96131612pacer
paces96741112paces
pacey126720282pacey
packet144726502packet
pact86648722pac_t
palet74650802palet
placet103923672placet
race66746262race_
raced87635312raced
racer75233022racer
races74943242races
rachet115028972rachet
racket125229422racket
ramet75743142ramet
sachet114725772sachet
stacte82113912stacte
taber73825822taber
tabes76033922tabes
tablet84227642tablet
tach96132752tac_h
tache106222372tache
taches114224172taches
tachs105820932tachs
tack106536292tac_k
tacked134723942tacked
tacker124224502tacker
tackets134914362tackets
tackey154613082tackey
tacks115430132tacks
tacky145617442tacky
taco67031352tac_o
tacos77023552tacos
tacts76524122tacts
tae38267052ta_e_
tael46030712ta_el
taint55542282taint
tajes124920692tajes
take84739262take_
taken94819142taken
taker95229002taker
takes94437792takes
talced93811002talced
tale46154162tale_
talent6323322talent
taler56034862taler
tales55451372tales
tame66343662tame_
tamed85528512tamed
tamer75230102tamer
tames75242012tames
tamest85721292tamest
tape64538142tape_
taped85327422taped
taper74829772taper
tapes75838602tapes
tapeta8310692tapeta
tappet103820112tappet
tare45957622tare_
tared69340052tared
tares57456562tares
target75028902target
tarot55943932tarot
tart47566182ta_rt
tasset65925312tasset
taste55127232taste
tat37690292ta__t
tate44748602tate_
tater54138612tater
tates55444982tates
taunt55532282taunt
taut47048962ta_ut
tawed95926192tawed
tawer85223442tawer
taxed135620292taxed
taxer125019362taxer
taxes124730822taxes
tenet55542212tenet
tercet83624912tercet
tet39274992t__et
ticket124524852ticket
trace75829612trace_
traced94821582traced
tracer84820232tracer
traces85329932traces
tract75635712trac_t
tret46653532t_ret
tucket124219482tucket
tweet84823982tweet
valet84337872valet
yacht13417392yacht

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.296603685.8
2DLD Change Limit538001321.64032804.9
3Display Results1321320.0462869.6
 (SQL Overall)1786911321.98290156.9
 
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.