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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

243 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
attrit631574(None) 
attrite7311831attrite
attrits7310611attrits
afrit8323172a_frit
astrict9614782astrict
atria56022332a_tria
atrip75315742a_trip
attain6311752attain
attaint7313472attaint
attent62818322attent
attest62618612attest
attic75618352att_ic
attire62412382attire
attract9511832attract
attrited947372attrited
attrites8311562attrites
yttria954802yttria
yttric1145432yttric
abort76133583abor_t
abri65522213a_bri_
abris75722603a_bris
abstrict1257933abstrict
acari75020283acari_
acarid95017063acarid
acquit17610323acquit
acrid86920103a_crid
actin74922553act_in
adit56443653a__dit
admit8319493a_dmit
adrift10313113a_drift
adroit7518783adroit
aerie54634603a_erie
afrits9311903a_frits
agaric93513623agaric
agorot7414993agorot
agria65517143a_gria
aigret73720023aigret
airt45757783a_ir_t
ait38093903a___it
albeit8314343albeit
aldrin7311243aldrin
alert54740653aler_t
alit46155693a__lit
alterity1149843alterity
altoist7313393altoist
altruist857953altruist
ambit94223713a_mbit
amorist9317643amorist
amort75832203amor_t
amrita8411133a_mrita
amtrac10109123amtrac
anti45536363ant_i_
antic75728863ant_ic
antiriot8414583antiriot
antis55033313ant_is
antra56521923antr_a
antral65719413antral
antre55224523antr_e
antres65021003antres
antrum8611313antrum
anuria6313103anuria
anuric8812093anuric
aorist64827873a_orist
aortic8316613aortic
apart74330673apar_t
aporia8315863aporia
aport75432173apor_t
apteria9312913apteria
aptest82917513aptest
aria46245423a__ria
arid57642713a__rid
aril45843023a__ril
armpit10811093armpit
arris56824683a_rris
art38679143a__r_t
artist64125543artist
asteria7316173asteria
astir55517093ast_ir
astral66919283astral
astray95615543astray
astricts1049453astricts
astride8311973astride
atavic11189293atavic
atavist10311093atavist
ataxia13179593ataxia
ataxic15169203ataxic
atelic8313703atelic
atheist10314053atheist
athirst1037873athirst
atilt54828473a_tilt
atomic104115603atomic
atomist92915763atomist
atonia63816513atonia
atonic83420473atonic
atopic103514143atopic
atrial65418943a_trial
atrium8411823a_trium
att35454653a_t__t
attach11118393attach
attack12148153attack
attains7310983attains
attaints846493attaints
attar56516693att_ar
attars64515313attars
attempt1145373attempt
attend7258973attend
attests7278813attests
atticist10811343atticist
attics84413283attics
attired8238913attired
attires72312953attires
attiring939483attiring
attorn6310793attorn
attorns738433attorns
attracts1047793attracts
attribute1153513attribute
attriting1048683attriting
attrition966963attrition
attritive1246073attritive
attritted1044493attritted
attune637983attune
atwain937813atwain
atypic13337653atypic
audit62527883a_udit
auric74521723a_uric
auris55331523a_uris
aurist65027253a_urist
autist64324943autist
avert86029493aver_t
await85524493a_wait
azurite1638003azurite
batterie10711533batterie
battik1238093batt_ik
brit66350153__brit
cantrip112910033cantrip
catsuit959383catsuit
cattail939173cattail
cattie85221013catt_ie
citric102812303citric
citrin82615403citrin
crit65743713__crit
daturic1047003daturic
esprit8312843esprit
estrin6315923estrin
fattest102913063fattest
forrit91916623forrit
frit77044473__frit
gastric1038623gastric
gastrin839823gastrin
grit55247243__grit
hatteria1137863hatteria
iatric8312153iatric
introit7414533introit
intuit6314083intuit
laterite8716333laterite
latria62313583latria
lattin64316223latt_in
mantric11311333mantric
matrix1539833matrix
mattin84416633matt_in
mattoid1079273mattoid
maturity1367433maturity
merit7339183_merit
metric10314673metric
metrist9317063metrist
naturist8410813naturist
nitric82512063nitric
nitrid72812233nitrid
nitril62511533nitril
nitrite72314463nitrite
nitwit938593nitwit
nutria639903nutria
outfit93014943outfit
outhit92818463outhit
outrig72812843outrig
outsit63620883outsit
outtrot7312613outtrot
outwit93014583outwit
outwrit10411413outwrit
patriot9314533patriot
pattie84020963patt_ie
petit74332653pet_it
pterin81014153pterin
putrid9311163putrid
rattail737793rattail
rattrap945263rattrap
retrim83514873retrim
satiric939243satiric
satirist8313503satirist
satori6415833satori_
satoris7317233satoris
satyric1237493satyric
satyrid1137233satyrid
spirit83519923spirit
sprit76736403_sprit
starlit71512913starlit
start55642313star_t
steric8317063steric
strait64025893strait
stria55723203_stria
strict84821043_strict
strip77524333_strip
stript85222193_stript
strut56030733_strut
sturt56028963stur_t
tacit76333673_tacit
tallit63422733tallit
tantric939573tantric
tarot55943933_tarot
tart47566183_tar_t
tattie64817513tattie
territ63421373territ
tetri52716453tetri_
tetris62816293tetris
thrift12412043_thrift
thrip103012183_thrip
tit36771043__t_it
titbit839823titbit
toit46353063__toit
tori47542153_tori_
toric76529313_toric
torii55521593_torii
torot56139943_torot
tort46967463_tor_t
trait56940843_trait
tret46653533__tret
trig55528163__trig
trim65329513__trim
trio45233343__trio
trip66830393__trip
trite54730033__trite
trot46351313__trot
turbit8715113_turbit
twit76329063__twit
untrim8310673untrim
uteri51012983uteri_
vitric112510113vitric
wastrie101210293wastrie
wattest102412153wattest
worrit92313313worrit
writ75537913__writ
yttrias1044513yttrias
yttrium1244103yttrium

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162435.97018880.4
3Display Results2432430.0763197.4
 (SQL Overall)1786912436.18628886.4
 
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.