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

64 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
biracial1210797(None) 
bifacial15105271bifacial
biradial1167711biradial
biaxial1645362bi_axial
bilabial1265682bilabial
biradical14105322biradical
brachial15219302b_rachial
racial83419242__racial
baronial1049483baronial
berascal1244853berascal
biaxal1536093bi_a_xal
biblical1445923biblical
bicaudal1343423bicaudal
biennial1065093biennial
bifacially2052683bifacially
bifocal1445373bifoc_al
bilabials1393653bilabials
bimanual1243753bimanual
binaural1045413binaural
binomial1246223binomial
biocidal1344943bi_ocidal
biosocial1344043biosocial
biotical1248863biotical
biracialism1753963biracialism
biradicals15103643biradicals
birdcall1343693birdcall
boracic1338723boraci_c
boracite1249193boracite
brachia141910423b_rachia_
brachials16206943b_rachials
bracing123817613b_racing
braciola1245273b_raciola
braciole1246973b_raciole
bracteal1245563b_racteal
brail75525553b_ra_i_l
branchial16215953b_ranchial
brasil8713863b_rasi_l
brazil1779623b_razi_l
breccial1444693breccial
burial84117623bur__ial
bursarial1154003bursarial
caracal11312513carac_al
cranial92114683_cranial
crucial1157893_crucial
facial113615633__facial
fiducial1443263fiducial
filarial1147863filarial
financial1443683financial
fractal1237623_fractal
geranial949283geranial
glacial1038143_glacial
miracidial1552293miracidial
nonracial1148093nonracial
piracies12312643piracies
piratical1348653piratical
rachial122012173__rachial
radial74020393__radial
spacial1138763_spacial
triaxial1545663triaxial
trifacial1444693trifacial
uracil8311543_uraci_l
vicarial1347793vicarial
viricidal1543843viricidal
virucidal1552453virucidal

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162647.73318901.1
3Display Results64640.0331939.4
 (SQL Overall)178691647.92222556.3
 
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.