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

127 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
bauxites173515(None) 
bauxite1635571bauxite_
augites8312182_augites
axites134913832_a_xites
barites94322332ba_rites
bauxitic1943622bauxitic
braunites1146722braunites
taxites1449672ta_xites
albites9313203_albites
alunites8310703alunites
aplites9314933_aplites
ascites9312603_ascites
audiles83112613_audiles
audited939033_audited
auditee8311573_auditee
auditees946463_auditees
audits72814113_audit_s
augite7312613_augite_
aunties73920073_aunties
auxeses1435623_auxeses
auxins13129813_auxi_ns
axises134413993_a_xises
axite125218253_a_xite_
azurites1737283azurites
babbitts1144023babbitts
babies106123653ba_bi_es
backbites19108633backbites
baddies114017873baddi_es
baffies153612943baffi_es
baggies113814853baggi_es
bagpipes1543403bagpipes
baguettes12115393baguettes
bailies94120203baili_es
baited95319243ba__ited
baiter84422553ba__iter
baiters94619303ba__iters
baits76630583ba__it_s
baizes174315053ba__izes
bakelites1545993bakelites
baldies105317703baldi_es
ballies93725743balli_es
ballutes1037523ballutes
bandies104124863bandi_es
banditos11347633banditos
bandits103814793bandit_s
bankits133410153bankit_s
banties94324763banti_es
baptises1238923baptises
baptizes2136843baptizes
barbies114519593barbi_es
barite84224813ba_rite_
barytes124611153ba_rytes
basaltes10367683basaltes
bastes85330383ba__stes
bastiles10313353bastiles
bates75846343ba___tes
batistes1039713batistes
baubees11348713bau_bees
baubles113611863bau_bles
bawdies134613393bawdi_es
bawties124214313bawti_es
beauties10229523beauti_es
biotites10310083biotites
bites75641173b___ites
blites84721213b__lites
boites84322703b__oites
bornites10310983bornites
bougies103715183bougi_es
bounties10311403bounties
braunite1047253braunite_
braxies16711463braxi_es
brucines1237763brucines
bruises93212913bru_ises
bruited104110353bru_ited
bruiter93710633bru_iter
bruiters10329143bru_iters
bruits85714453bru_it_s
brutes86118683bru__tes
bruxes154811023brux__es
bruxisms1942943bruxisms
buries84633273b_uri_es
burkites1436673burkites
busies85525263b_usi_es
butes714535873b_u__tes
buttes84822563b_u_ttes
butties93217953b_utties
calcites12313003calcites
caudates11310263caudates
caudices13337343caudices
crudites1137763crudites
curites93919863_curites
dacites101114593da_cites
dauties83315763dauti_es
dunites8313593_dunites
equites162212493equ_ites
gahnites1235703gahnites
gaudies9311973gaudi_es
gunites8313123_gunites
halites103221193ha_lites
haplites1339993haplites
jadeites1645823jadeites
kainites1238793kainites
kauries113613193kauri_es
lauwines1145713lauwines
laxities1539093la_xities
lazulites1844253lazulites
lazurites1844583lazurites
leucites1037333leucites
lucites9311863_lucites
luxates1436973_luxates
mannites10312613mannites
marlites103415263marlites
marmites122212793marmites
maxixes1535253ma_xixes
paucities1348503paucities
ratites74920683ra_tites
raucities1148163raucities
reunites8312473reunites
samites93118713sa_mites
sauries72821623sauri_es
sautes63924913sau__tes
suites63727403_su_ites
taurines8310553taurines
taxies135817333ta_xi_es
taxite13511303ta_xite_
ulexites1534943ulexites
unites65024853__unites

Search took 33 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 Filter1786911461620.703254183.5
2DLD Change Limit14616212731.1104698.2
3Display Results1271270.156814.1
 (SQL Overall)17869112731.9695589.5
 
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.