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

187 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
biaxal153609(None) 
biaxial1645361biaxial
axal116520492__axal
baal67033112b_a_al
banal75925992b_anal
basal75722282b_asal
bharal1138892bharal
binal75323822bi_nal
coaxal15387302coaxal
hiatal9310202hiatal
aal39058673__a_al
abaxial1646183abaxial
adaxial1545323adaxial
anal48037523__anal
atabal839743atabal
axel115222073__axel
axial124515193__axial
axil116424453__axil
baa510650423b_a_a_
baals76122703b_a_als
baas66844673b_a_as
baba88828353b_aba_
babas96325733b_abas
babel95821693b_abel
babul96317713b_abul
bagel85116793b_agel
bail65042803b_a_il
baiza164813223baiza_
baizas173810823baizas
bal56662723b___al
balas76937213b_alas
ball66043323b_a_ll
barbal104016663barbal
basalt83519583b_asalt
basil75122273b_asil
bawl95326063b_a_wl
bazar163816003b_azar
benzal1739643benzal
bharals1236733bharals
biali73419073bia_li
bialis83617163bialis
bialy105119323bia_ly
bialys11387913bialys
biannual1043323biannual
bias64738163bi__as
biased94012223biased
biases84618433biases
biaxially2143693biaxially
bicaudal1343423bicaudal
bifacial15105273bifacial
bifocal1445373bifocal
bilabial1265683bilabial
bill67239943bi__ll
bima86723833bi_ma_
bimah127013273bi_mah
bimanual1243753bimanual
bimas95521743bi_mas
bimetal1138433bimetal
bimodal1245663bimodal
binaural1045413binaural
biogas94310913biogas
biota74516823biota_
biotas84313923biotas
bipedal1245683bipedal
biracial12107973biracial
biradial1167713biradial
birl65830473bi__rl
bisexual1743803bisexual
bitmap1235613bitmap
bizonal1845563bizonal
boatel84314093boatel
boral75831703b_oral
boreal84817213boreal
bradawl1344363bradawl
brail75525553bra_il
brasil8713863brasil
brava106414793brava_
bravas114913323bravas
brawl106217963bra_wl
braxy175410893brax_y
braza165214253braza_
brazas175812433brazas
brazil1779623brazil
bridal9511453bridal
bromal10313653bromal
brumal1049503brumal
brutal859383brutal
bubal94218213b_ubal
buccal1248243buccal
burial84117623burial
bursal84414823bursal
bwana10310243bwana_
bwanas1157443bwanas
byssal1134993byssal
cabal95222153_cabal
canal75428043_canal
citral81113893citral
coaxial16157003coaxial
coxal146116673_coxal
craal74117753cra_al
dial55935063di__al
dioxan1465773dioxan
dismal92412243dismal
distal73615773distal
fatal84819373_fatal
filial93013253filial
final83922033fi_nal
finial92814183finial
fiscal1139333fiscal
gayal9312713_gayal
gimbal11228813gimbal
gimmal11247513gimmal
gingal81010153gingal
graal64316503gra_al
hadal95518123_hadal
halal85623593_halal
hamal104623113_hamal
hiemal11339503hiemal
ideal65716393_ideal
ileal56118083_ileal
ilial55317843_ilial
jacal14313703_jacal
jingal1498593jingal
kraal94511823kra_al
laical8312323laical
liana53915893liana_
lianas63713383lianas
lienal63912783lienal
lineal65616023lineal
meatal84114733meatal
miasmal1176743miasmal
miaul71612123mia_ul
miskal123710263miskal
missal84314903missal
mitral81314323mitral
nasal56217593_nasal
natal53921493_natal
naval85315833_naval
nidal65217103ni_dal
nival84915773ni_val
papal95820673_papal
pial65636703pi__al
pibal95217323pi_bal
pical95524373pi_cal
pineal84817683pineal
pinnal84814273pinnal
pipal95118353pi_pal
pixel143911903pi_xel
plagal948573plagal
plexal1536833plexal
ramal74622243_ramal
ratal55025113_ratal
rial45938093ri__al
riata54618023riata_
riatas63915093riatas
rictal83113183rictal
ritual6310623ritual
rival85216503ri_val
riyal84413433ri_yal
sabal75422483_sabal
salal55425703_salal
sial45938833si__al
signal73711483signal
sisal54217733si_sal
statal61613223statal
tamal73522623_tamal
taxa116820093_taxa_
taxol124011363_taxol
tiara5315913tiara_
tiaras6314553tiaras
tibial849843tibial
tical76021493ti_cal
tidal64516443ti_dal
timbal102510753timbal
tincal83913363tincal
tineal66216163tineal
triaxial1545663triaxial
uniaxial1543883uniaxial
vagal94613633_vagal
vasal85516293_vasal
vial76731093vi__al
vinal85725813vi_nal
vineal94814743vineal
viral86419593vi_ral
visual938803visual
vital84819673vi_tal
withal1238933withal

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161875.56020272.7
3Display Results1871870.0632968.3
 (SQL Overall)1786911875.76630990.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.