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

62 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
biradial116771(None) 
biracial12107971biracial
biradical14105321biradical
biaxial1645362bi_axial
bifacial15105272bifacial
bilabial1265682bilabial
biradicals15103642biradicals
radial74020392__radial
baronial1049483baronial
basidial1145623basidial
berascal1244853berascal
biaxal1536093bi_a_xal
bicaudal1343423bicaudal
biennial1065093biennial
bilabials1393653bilabials
bimanual1243753bimanual
bimodal1245663bimod_al
binaural1045413binaural
binomial1246223binomial
biocidal1344943biocidal
bipedal1245683biped_al
birdcall1343693bir_dcall
birdie94013783bir_di_e
birdied11329433bir_died
birdies104016213bir_dies
birding114014923bir_ding
birdman1236673bir_dman
brachial15219303b_rachial
bradawl1344363b_radawl
brail75525553b_ra_i_l
brasil8713863b_rasi_l
brazil1779623b_razi_l
bridal9511453b_rid_al
burial84117623bur__ial
bursarial1154003bursarial
circadian1443693circadian
cordial10312943cor_dial
cranial92114683_cranial
filarial1147863filarial
geranial949283geranial
giardia945563giardia_
giardias1045023giardias
gonadial1066823gonadial
gradual936943_gradual
miracidial1552293miracidial
misdial1039643mi_sdial
paradisal1246883paradisal
peridial11411923peridial
piratical1348653piratical
praedial1178763_praedial
prandial1149643_prandial
predial103815413_predial
racial83419243__racial
radiale83813523__radiale
radials83614633__radials
radian74117273__radian
radical103312793__radical
redial74923113__redial
triaxial1545663triaxial
uredial82910483_uredial
vicarial1347793vicarial
viridian1245103viridian

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 Limit146162627.76318828.0
3Display Results62620.0163875.0
 (SQL Overall)178691627.93522519.3
 
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.