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

126 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
basilic113749(None) 
basilica1244351basilica
bailie83818362ba_ilie
basaltic1245152basaltic
basic96220522bas__ic
basidia1047612basidia
basil75122272basil__
basilar937302basilar
basilect1245902basilect
basilicae1343122basilicae
basilical1344202basilical
basilican1343202basilican
basilicas1343732basilicas
basilisk1444052basilisk
basils85717472basil_s
brasilin1046962brasilin
aboulic1156283aboulic
abulic106411423_abulic
acidic113612133_acidic
acinic104713543_acinic
adipic1137263_adipic
amidic114012873_amidic
aminic104413513_aminic
amylic13108713_amylic
anilin6417793_anilin
anisic8313793_anisic
ascitic1139323_ascitic
asdic83814093_as_dic
aspic95114733_as_pic
atelic8313703_atelic
aulic74420243_a_ulic
baalim1038473ba_alim
bacchic1545813bacchic
bacilli1146393bacilli
backlit15911903backlit
bail65042803ba_il__
bailed94726653ba_iled
bailee84526013ba_ilee
bailer85425253ba_iler
bailey115015673ba_iley
bailies94120203ba_ilies
bailiff1546073ba_iliff
bailing103723523ba_iling
bailor83412603ba_ilor
bails75933523ba_il_s
baldric12166403baldric
balsamic1463803balsamic
bardic11312923ba_rdic
baric96125693ba__ric
barilla9310323barilla
barytic1437823barytic
basal75722283basal__
basally1237963basally
basalt83519583basal_t
basalts9358963basalts
baseline10310753baseline
basely114412313basel_y
bashlyk1942463bashlyk
basicity1546313basicity
basics104915123basi_cs
basidial1145623basidial
basidium1345103basidium
basified1437823basified
basifier1337313basifier
basifies13310493basifies
basify1437513basi_fy
basilary1345063basilary
basilects1342973basilects
basilisks1543103basilisks
basin75026923bas__in
basinal9310033basinal
basined10310003basined
basinet9318933basinet
basing95427663basi_ng
basinlike1553383basinlike
basins85722763basi_ns
basion84315853basi_on
basions94213953basions
basis75429863bas__is
basophilic1953953basophilic
bassi77019323bas_si_
bassly114610073bassl_y
bastile9313913bastil_e
bastiles10313353bastiles
bastille1048003bastille
bauxitic1943623bauxitic
bawdric15164583bawdric
beatific1544223beatific
beylic1337823b_eylic
bosonic1139213bosonic
brasil8713863brasil__
brasilein1143063brasilein
brasilins1146243brasilins
brasils9410973brasil_s
brazilin1944383brazilin
bucolic1345593bucolic
bulimic1345143bulimic
busily112211503busil_y
bustic101012693bus_tic
caseic103212373cas_eic
casini84615863casini_
easily9313023easil_y
eosinic947713eosinic
exilic1597783_exilic
fatidic1345723fatidic
gallic9411643ga_llic
garlic9310043ga_rlic
gaslit7513503gas_lit
gastric1038643gastric
jaditic1746703jaditic
malic94525663ma__lic
masonic1139913masonic
mastic103119173mas_tic
mastitic1248263mastitic
nastic82915973nas_tic
ossific1243103ossific
pacific1646913pacific
pashalic1546183pashalic
ramilie9310283ramilie
resilin72913973resilin
salic73424713__salic
satiric939253satiric
sialic8313633__sialic
silica8311243__silica
taxitic1637093taxitic
vanillic1344263vanillic

Search took 7 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.453394461.4
2DLD Change Limit1340271266.26621389.6
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.76526414.0
 
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.