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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
boracite124919(None) 
boracites1347941boracites
boracic1338722boraci_c
borate85026152bora__te
bornite9311182bor_nite
voracity1645532voracity
barite84224813b__arite
berate84729023bera__te
biracial12107973biracial
bobwhite1842423bobwhite
boccie123311453bo_cci_e
boehmite1583153boehmite
boite74426323bo___ite
bonaci10310963bonaci__
bonacis11310323bonaci_s
boraces113716853borac_es
borage93917013bora__ge
borane84620213bora__ne
borated104116363bora__ted
borates94823013bora__tes
borating113414503borating
borecole1246623borecole
boride9415903bor__ide
bornites10310973bor_nites
borscht1445993borscht_
borschts1542853borschts
botanise1039643botanise
botanize1948743botanize
brace95629273b_rac__e
brachet144020313b_rachet
brachiate1646873b_rachiate
bracing123817613b_racing
braciole1246973b_raciole
bracket154117233b_racket
bract96332723b_rac_t_
bracted12410933b_rac_ted
bracts105617773b_rac_ts
braise84318753b_ra_ise
braize174113113b_ra_ize
braunite1047253b_raunite
brookite1445503brookite
brucine1138273b_rucine
burkite1337003bur_kite
coracle112011723corac_le
cordite10315253cor_dite
dacite91115883__dacite
feracity1646733feracity
gracile102512603_gracile
granite82017083_granite
kamacite1645293kamacite
localite101411543localite
loricate10310663loricate
monazite1957083monazite
moraine9314573mora_ine
moralise10314913moralise
morality131110333morality
moralize19313923moralize
mordacity1743513mordacity
morganite1247423morganite
norite63221133nor__ite
opacity1436313_opacity
orache114013593_orac_he
oracle84313293_orac_le
orality101111683_orality
orate55133303_ora__te
parakite14410423parakite
parasite10314843parasite
porcine11312843por_cine
ratite65022423__ratite
recite83625113__recite
rolamite1048743rolamite
ruralite848963ruralite
sodalite9109593sodalite
soricine10710883soricine
uralite71714103_uralite
uranite72515693_uranite
veracity1647553veracity
voracities1547063voracities
zaratite1747793zaratite

Search took 9 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.1701051123.5
2DLD Change Limit146162798.09318060.3
3Display Results79790.0631254.0
 (SQL Overall)178691798.32621461.8
 
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.