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

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

97 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
attract951183(None) 
attracts1047791attracts
abstract1249222abstract
amtrac10109132amtrac_
amtrack15107392amtrack
amtracs1198882amtracs
astrict9614792astrict
attach11118392att_ach
attack12148152att_ack
attracted1246072attracted
attracter1146092attracter
attractor1145822attractor
attrit6315752attr_it
cataract1249412cataract
detract101414632detract
extract16311012extract
retract91318112retract
tract75635712__tract
abreact11310823abreact
abstracts1346593abstracts
abstrict1257943abstrict
alterant8614963alterant
amtracks1696633amtracks
antra56521923antra__
antral65719413antra_l
arrack121110253a_rrack
arrant6623253a_rrant
artefact1345183artefact
artifact1346143artifact
astral66919283astra_l
astrals75515243astrals
astray95615543astra_y
astricts1049463astricts
ataractic1346233ataractic
ataraxy1743983ataraxy
athwart1348683athwart
attache12106693att_ache
attacks13126943att_acks
attain6311753att_ain
attaint7313473attaint
attar56516693att_a_r
attars64515313att_ars
attempt1145373attempt
attent62818323att_ent
attest62618613att_est
attic75618353att_ic_
attics84413283att_ics
attractant1254153attractant
attracters1245113attracters
attracting1346563attracting
attraction1276953attraction
attractive1545553attractive
attractors1245843attractors
attrite7311833attrite
attrits7310613attrits
autarch1246623autarch
bract96332723__bract
cataracts1345583cataracts
contract122915633contract
detracts11138833detracts
distract11313023distract
entrant7318873entrant
extracts1747623extracts
hatrack1638213hatrack
infract12610003infract
intact8314663int_act
interact10316473interact
intrant7318753intrant
iterant7317783iterant
mattrass1045863mattrass
ostraca937823ostraca
outact8317203out_act
outrace92418553outrace
overact12315043overact
protract12510603protract
rattrap945263rattra_p
rattraps1044823rattraps
refract121311603refract
retrace91417343retrace
retrack131310723retrack
retracts101111313retracts
retroact10410003retroact
saturant8410643saturant
strait64025893_strait
strict84821043_strict
subtract1249583subtract
tact67349033__t_act
titrant7315193titrant
trace75829613__trace
track114823013__track
tracts85019073__tracts
trait56940843__trait
trapt76433393__trapt
turaco839453_turaco
tyrant9315333_tyrant
untrack1338703untrack
yttric1145433yttric_

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit134027976.50020619.5
3Display Results97970.0332939.4
 (SQL Overall)178691976.92325811.2
 
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.