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

182 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
attrite731183(None) 
attrit6315751attrit_
attrited947371attrited
attrites8311561attrites
attrits7310611attrits
astride8311972astride
attire62412382att_ire
attribute1153512attribute
attritive1246072attritive
attritted1044492attritted
azurite1638002azurite
laterite8716342laterite
nitrite72314462nitrite
trite54730032__trite
acarine9316003acarine
accrete1137843accrete
acerate92818913acerate
aconite9315473aconite
active11313743act_ive
actuate9311443actuate
aerate64830553a_erate
aerie54634603a_eri_e
afrit8323173a_frit_
afrits9311903a_frits
airtime948063airtime
albite8313313a_lbite
alterity1149843alterity
alunite7311633alunite
amirate91115953amirate
amosite9313163amosite
amrita8411133a_mrita
ankerite1248923ankerite
antlike11312073antlike
antre55224523antr__e
apatite9312963apatite
aplite8316393a_plite
apprise11310193apprise
apprize2038183apprize
arenite71017713arenite
arete56031353a__rete
arise56436433a__rise
arrive91311793a_rrive
artiste73813693artiste
ascribe1147743ascribe
astrict9614793astrict
astricted1247443astricted
astricts1049463astricts
astringe938223astringe
astute6310763ast_ute
atabrine1045203atabrine
athlete1068083athlete
atomise93013823atomise
atomize183111823atomize
atria56022343a_tri_a
atrial65418943a_trial
atrip75315753a_tri_p
atrium8411823a_trium
attache12106693attache
attain6311753attai_n
attained997353attained
attainer8116913attainer
attains7310983attains
attaint7313473attaint
attainted1044693attainted
attaints846493attaints
attent62818323attent_
attest62618613attest_
attested936293attested
attester836503attester
attests7278813attests
attic75618353att_i_c
atticize1948443atticize
attics84413283att_ics
attired8238913attired
attires72312953attires
attiring939483attiring
attitude9196033att_itude
attract9511833attract
attracted1246073attracted
attracter1146093attracter
attracts1047793attracts
attributed1352723attributed
attributes1253363attributes
attriting1048683attriting
attrition966963attrition
attune637983att_une
augite7312613a_ugite
aurate64426473a_urate
autunite856693autunite
avarice1238033avarice
axite125218253a__xite
azurites1737283azurites
barite84224813_barite
batterie10711533batteri_e
castrate10313863castrate
catamite12510593catamite
cattie85221023catt_i_e
cerite84724873_cerite
citrate92216803citrate
citrine92514023citrine
contrite10318543contrite
cowrite123612683cowrite
cuprite1159683cuprite
curite85222943_curite
diorite8314913diorite
elaterite949733elaterite
eucrite939903eucrite
favorite1447313favorite
ferrite103312753ferrite
gothite1146403gothite
iterate71119113iterate
laborite10410703laborite
laetrile845203laetrile
laterites9715063laterites
laterize17613303laterize
latrine7715133latrine
lattice938433latt_ice
lazurite1745243lazurite
maturate10312623maturate
maturity1367443maturity
nitrate72017013nitrate
nitride82811243nitride
nitrile73011373nitrile
nitrites82313453nitrites
norite63221133_norite
outrate72323183outrate
outride82615683outride
outwrite1139453outwrite
partite9317133part_ite
patriate10311933patriate
pattie84020963patt_i_e
petite84320653pet_ite
picrite111911313picrite
pyrite11913313_pyrite
ratite65022423rat_ite
rewrite10311143rewrite
rite45849453___rite
satirise8310683satirise
satirize1749703satirize
saturate8312813saturate
sprite84421773_sprite
sterile7316603sterile
sternite8310543sternite
striae65422273_striae
striate74218953_striate
stride75420963_stride
strife95318363_strife
strike105619733_strike
stripe85822443_stripe
strive95020963_strive
stylite10219613stylite
tacrine9311293tacrine
tartrate899683tartrate
tattie64817513tatti_e
taurine7311363taurine
taxite13511303_taxite
terete6319333_terete
tergite8311003_tergite
termite9313893_termite
thorite10313443thorite
thrice114311573_thrice
thrive125313223_thrive
titrate72215573titrate
torte55431703_tor_te
tribe74420273__tribe
trice75127493__trice
trike95320163__trike
trine54734603__trine
tripe75425383__tripe
triste63818643__triste
triter65120593__triter
turgite837973_turgite
uterine7315193uterine
verite94323443_verite
vitrine102511363vitrine
wastrie101210303wastri_e
write85522833__write
yperite1249893yperite
yttria954803yttri_a
yttrias1044523yttrias
yttric1145433yttri_c
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 Filter1786911340270.406440125.6
2DLD Change Limit1340271826.42320866.7
3Display Results1821820.0603033.3
 (SQL Overall)1786911826.88925938.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.