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

162 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
basilar93731(None) 
basilary1345071basilary
ashlar9338202_ashlar
bacillar1276542bacillar
bailer85425252ba_iler
bailor83412602ba_ilor
basil75122272basil__
basilic1137492basilic
basils85717472basil_s
basinal9310032basinal
bifilar1244042bifilar
abasia8712953abasi_a_
abasias9711023abasi_as
acinar8310483_acinar
alar46340073_a__lar
alular6311363_alular
ashlars10297063_ashlars
ashler9459973_ashler
astylar10265063_astylar
asyla839333_asyla_
axillar14247563_axillar
babbler104012823babbler
babier103515573babi_er
bacalao1146613bacalao
bacillary1673973bacillary
bacilli1146403bacilli
bacula103112693bacula_
baffler15418113baffler
bail65042803ba_il__
bailed94726653ba_iled
bailee84526013ba_ilee
bailers94221353ba_ilers
bailey115015673ba_iley
bailie83818363ba_ilie
bailors93212413ba_ilors
bails75933523ba_il_s
baiter84422563ba_iter
baiza164813223ba_iza_
baizas173810823ba_izas
balas76937213ba__las
baler75635283ba__ler
balisaur1043263balisaur
ballad94315323ba_llad
baller83825203ba_ller
banian8315383bani_an
barilla9310333barilla
barillas10310203barillas
basal75722283bas__al
basally1237963basally
basalt83519583basal_t
basalts9358963basalts
basely114412313basel_y
baseman1138553baseman
baser74828923bas__er
bashaw14349303bas_haw
basher115123813bas_her
bashlyk1942463bashlyk
basic96220523basi__c
basics104915123basi_cs
basidia1047623basidia
basidial1145623basidial
basifier1337313basifier
basify1437513basi_fy
basilect1245903basilect
basilica1244353basilica
basilicae1343123basilicae
basilical1344203basilical
basilican1343203basilican
basilicas1343733basilicas
basilisk1444053basilisk
basin75026923basi__n
basined10310003basined
basinet9318933basinet
basing95427663basi_ng
basins85722763basi_ns
basion84315853basi_on
basions94213953basions
basis75429863basi__s
bassly114610073bassl_y
bastard103012423bas_tard
baster85333603bas_ter
bastile9313913bastil_e
bastiles10313353bastiles
bastille1048003bastille
battler94113383battler
bawler114315053ba_wler
bazaar17306403ba_zaar
bazar163816003ba__zar
besmear1134833besmear
bipolar1145463bipolar
blastular1143023blastular
boiler84319273b_oiler
bolar75123473b__olar
bolivar1244853bolivar
brasier94516753brasi_er
brasil8713863brasil__
brasilin1046963brasilin
brasils9410973brasil_s
briar75718153b_ri_ar
broiler92911753broiler
burglar1065533burglar
busbar1038453bus_bar
busier85219723busi_er
busily112211503busil_y
bustler94012573bustler
canular9310333canular
capsular1245413capsular
casita82913703casita_
casitas93312043casitas
caviar11310163cavi_ar
caviler1249063caviler
easier64218463easi_er
easily9313023easil_y
fabular12288703fabular
facular122810453facular
familiar1365953familiar
filar84819293__filar
hailer94720343ha_iler
hamular1236983hamular
hilar85418143__hilar
insular7138713insular
jailer134316683ja_iler
jailor13418573ja_ilor
laminar93810283laminar
lascar868573las_car
lashkar1443703lashkar
macular113011953macular
mailer84724183ma_iler
malar76424443ma__lar
manila84518303manila_
manilas93915873manilas
masala8311823masala_
masalas9312073masalas
nailer64119363na_iler
nasial6413283nasi_al
pabular11259483pabular
palikar1335463palikar
papillar1296733papillar
papular11299773papular
pilar75221503__pilar
pupilar11125323pupilar
radular837843radular
railcar945483ra_ilcar
railer64524933ra_iler
ranular739443ranular
sailer63526103sa_iler
sailor63113753sa_ilor
simar74920813__simar
similar937853similar
sitar54820543__sitar
sizar145214993__sizar
solar55927343__solar
tabular9279773tabular
tahsildar135883tahsildar
tailer63823733ta_iler
tailor63412503ta_ilor
talar56225383ta__lar
taskbar1393023taskbar
tonsilar843953tonsilar
variolar1176343variolar
vascular1346303vascular
wailer93720333wa_iler

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271627.98616782.7
3Display Results1621620.1231317.1
 (SQL Overall)1786911628.51520985.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.