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

130 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
azurite163800(None) 
azurites1737281azurites
lazurite1745241lazurite
alunite7311632alunite
attrite7311832attrite
augite7312612a_ugite
aurate64426472a_urate
azure14911482azur__e
curite85222942_curite
lazulite1745032lazulite
lazurites1844582lazurites
abusive1245283abusive
acarine9316003acarine
accrete1137843accrete
accurate12410663accurate
acerate92818913acerate
aconite9315473aconite
acuate8315633acu_ate
acuity1139373acu_ity
acute74720363acu__te
adulate8313233adulate
aerate64830553a_erate
aerie54634603a_eri_e
afrit8323173a_frit_
afrits9311903a_frits
albite8313313a_lbite
alumine9412693alumine
alunites8310703alunites
amirate91115953amirate
amosite9313163amosite
amrita8411133a_mrita
amusive1246253amusive
ankerite1248923ankerite
anuria6313123anuri_a
anurias7312253anurias
anuric8812103anuri_c
apatite9312963apatite
aplite8316393a_plite
apprise11310193apprise
apprize2038183apprize
arenite71017713arenite
arete56031353a__rete
arise56436433a__rise
arrive91311793a_rrive
ascribe1147743ascribe
astride8311973astride
attrit6315753attrit_
attrited947373attrited
attrites8311563attrites
attrits7310613attrits
audile73315303a_udile
audit62527883a_udit_
audited939033a_udited
auditee8311573a_uditee
audits72814113a_udits
augites8312183a_ugites
auntie64317703a_untie
aurae54128113a_ur_ae
aurated83817793a_urated
aureate72515283a_ureate
auric74521733a_uri_c
auricle9139813a_uricle
auris55331533a_uri_s
aurist65027253a_urist
aurists74615783a_urists
autunite856693autunite
avarice1238033avarice
axite125218253a__xite
azide155617163az__ide
azine146721413az__ine
azote144416343az__ote
azotise1637073azotise
azotize1537083azotize
azuki1864803azuki__
azukis1963733azuki_s
azures15510183azur_es
barite84224813_barite
bauxite1635573bauxite
burkite1337003_burkite
cerite84724873_cerite
cowrite123612683cowrite
cuprite1159683cuprite
curate85226243_curate
curiae84518373_curiae
curie74533043_curi_e
curites93919863_curites
diorite8314913diorite
dourine8311453dourine
dunite7315013_dunite
erudite838483erudite
eucrite939903eucrite
favorite1447313favorite
ferrite103312753ferrite
fluorite1147893fluorite
gunite7414403_gunite
laborite10410693laborite
laterite8716333laterite
lazulites1844253lazulites
leucite937753leucite
lucite8313343_lucite
maturate10312613maturate
maturity1367433maturity
muriate9313363_muriate
murine84220023_murine
neurine7311683neurine
nitrite72314463nitrite
norite63221133_norite
ourie54027303_ouri_e
picrite111911313picrite
purine85321893_purine
purity114114913_purity
pyrite11913313_pyrite
quite144621463_qu_ite
reunite7312713reunite
rewrite10311143rewrite
rite45849453___rite
saturate8312813saturate
sprite84421773_sprite
suite54829563_su_ite
taurine7311363taurine
thorite10313443thorite
trite54730033__trite
turgite837973_turgite
tzuris15286913tzuri_s
unite54828383__unite
urate55432163__urate
urine55026603__urine
verite94323443_verite
write85522833__write
yperite1249893yperite

Search took 8 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.403443402.0
2DLD Change Limit1340271307.00319138.5
3Display Results1301300.0433023.3
 (SQL Overall)1786911307.44923988.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.