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

223 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
alunite731163(None) 
alunites8310701alunites
aconite9315472aconite
alanine7316862alanine
albite8313312al_bite
allanite8411092allanite
alumine9412692alumine
arenite71017712arenite
augite7312612a_ugite
auntie64317702a_untie
autunite856692autunite
azurite1638002azurite
dunite7315012_dunite
galenite91210062galenite
gunite7414402_gunite
lenite6719982_lenite
lucite8313342_lucite
lunate6316042_lunate
reunite7312712reunite
unite54828382__unite
abusive1245283abusive
aconites10314353aconites
acuate8315633acu_ate
acuity1139373acu_ity
acute74720363acu__te
adenine8311213adenine
adnate72913483a_dnate
adulate8313233adulate
aduncate1145573aduncate
agenize172910153agenize
agnate73314883a_gnate
agnize16329563a_gnize
agonise83112693agonise
agonize172911403agonize
alane56135613alan__e
alanin6317273alani_n
alanines8314803alanines
alanins7315803alanins
alant55742293alan_t_
alants67722023alan_ts
alate55340333al__ate
albeit8314343albeit_
albites9313203al_bites
alcaide1088453alcaide
alewife1344923alewife
alexine142410543alexine
alginate9310693alginate
alienate8311553alienate
alike95523963al__ike
aline57243153al__ine
alining81917043alining
alit46155693al__it_
aliunde835003aliun_de
alive85722513al__ive
alkie95520033al_ki_e
alkine104916803al_kine
allanites949803allanites
allusive1144783allusive
almandite1245093almandite
alnico877943al_nico
alone55732963alon__e
alpine84417373al_pine
alsike1047913al_sike
alulae6312743alu_lae
alumin8513543alumi_n
alumina9510053alumina
aluminate1149373aluminate
alumines10411683alumines
aluminize2045903aluminize
alumins9512983alumins
alumnae955403alumnae
alumni856753alumni__
alvine94614583al_vine
amanita9310453amanita
amenity1238333amenity
aminity12310513aminity
ammonite1249143ammonite
amniote936963a_mniote
amosite9313163amosite
amusive1246253amusive
anile54634463a__nile
anime75423203a__nime
anise55129703a__nise
annuity1045543annuity
ante46538903a__n_te
apatite9312963apatite
aphanite1348773aphanite
aplite8316393a_plite
arenites8917103arenites
arsenite8119663arsenite
asinine7310723asinine
attrite7311833attrite
audile73315303a_udile
audit62527883a_udit_
audited939033a_udited
auditee8311573a_uditee
audits72814113a_udits
augites8312183a_ugites
aunt46553653a_un_t_
aunties73920073a_unties
aunts55227633a_un_ts
aunty85919813a_un_ty
aurate64426473a_urate
autunites946203autunites
axite125218253a__xite
azurites1737283azurites
bauxite1635573bauxite
blite76225353bl__ite
blunge94311483blun_ge
blunt75525023blun_t_
blunted104210663blun_ted
blunter94512033blun_ter
blunts84512893blun_ts
bornite9311183bornite
braunite1047253braunite
calamite12312533calamite
calcite11413783cal_cite
calumniate1444103calumniate
crinite9513633crinite
curite85222943_curite
cyanite122710763cyanite
disunite999303disunite
dunites8313593_dunites
dunnite857333dunnite
ebonite9310293ebonite
elite56230183el__ite
eluate62315433elu_ate
elusive1057003elusive
elute54822573elu__te
eluviate1146953eluviate
erudite838483erudite
finite9316823_finite
flinkite1543623flinkite
flite85424963fl__ite
flunkie1434513flunkie
fluorite1147893fluorite
flute86823753flu__te
gahnite1135973gahnite
galenites10129183galenites
glute66020903glu__te
granite82017083granite
gunites8313123_gunites
halite93624233hal__ite
ichnite1245983ichnite
ignite71410583_ignite
illite63414923il_lite
ilmenite1046223ilmenite
kainite1149543kainite
kaolinite1344043kaolinite
kernite1159473kernite
kunzite2053503_kunzite
kyanite14237313kyanite
lacunate10128963lacunate
lanate6421263_lanate
launce8469183laun_ce
lauwine1036373lauwine
lazulite1745033lazulite
lazurite1745243lazurite
lenited8812433_lenited
lenites7818443_lenites
lenity9612713_lenity
leucite937753leucite
lignite81310303lignite
lite47054543_l__ite
lucites9311863_lucites
lunated8310823_lunated
lune47140493_lun__e
lunet56835423_lunet_
lunets66914763_lunets
lunette737483_lunette
lunge65323803_lun_ge
lungee75119813_lungee
lunier64617603_lunier
lunies64723013_lunies
lunt46148843_lun_t_
lunted74517523_lun_ted
lunts55826903_lun_ts
lunule638433_lunule
lupine84013533_lupine
lute46341013_lu__te
luxate1338083_luxate
mannite9312903mannite
masonite1049683masonite
melanite10512033melanite
melinite10411753melinite
mullite9313013mullite
mylonite1346823mylonite
nite45943583___nite
pinite8321243_pinite
planate9314573planate
plumate1149803plumate
plunge93811053plun_ge
preunite1039573preunite
quinte153414523_quinte
quite144621463_qu_ite
reunited939713reunited
reuniter838323reuniter
reunites8312473reunites
salinity1138893salinity
salinize1739683salinize
salute64418023salu__te
saponite10410533saponite
selenite81713113selenite
sienite7312713sienite
slainte738543slainte
sluice849513slu_ice
suite54829563_su_ite
sulfite10310473sulfite
syenite1039773syenite
taconite1049313taconite
ulexite1445723ulexite
ululate749963ululate
unit45140073__unit_
united74421543__united
uniter64619143__uniter
unites65024853__unites
units54923433__units
unity84918493__unity
untie54425493__untie
ununited938683ununited
uranite72515693uranite
valuate102512733valu_ate
vauntie1036633vauntie

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 Limit1340272236.01622278.4
3Display Results2232230.0762934.2
 (SQL Overall)1786912236.49827499.4
 
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.