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

122 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
fasciae124752(None) 
faciae112913411fa_ciae
fascia1148701fascia_
fascial1258301fascial
fascias1258411fascias
fasciate1347561fasciate
fascine12510581fascine
facia103218462fa_cia_
facial113615632fa_cial
facias113415802fa_cias
facile112514882fa_cile
farcie114816472farci_e
fasciated1546132fasciated
fascicle1554632fascicle
fascinate1447762fascinate
fascines13310142fascines
fascism1436442fascism
fascist1239212fascist
faucial1257322faucial
abscise1145953abscise
aecia73819283_aecia_
aecial84817313_aecial
asci66519143_asci__
ascites9312603_ascites
ascribe1147743_ascribe
aside65122083_as_ide
asocial998653_asocial
aspire8612123_aspire
assize1538633_assize
baccae12119703ba_ccae
bascule1136573bascule
bastile9313913bastile
calcine11315273calcine
calcite11413783calcite
cardiae10713703cardiae
cascade12118603cascade
cassia83714763cassia_
cassias93514343cassias
cassine93817283cassine
dacite91115883da_cite
dassie74615573dassi_e
fabliau1244903fabliau
facade1238803fa_cade
face96140123fa_c__e
facete115014833fa_cete
facetiae1346213facetiae
facials123310743fa_cials
facies113921593fa_cies
facing125321573fa_cing
faculae123210353faculae
fadlike15318483fadlike
faecal11359813faec_al
faerie93514683faeri_e
falcate12311613falcate
falsie93513853falsi_e
famine114318193fa_mine
fancied133310603fancied
fancier123412063fancier
fancies124018783fancies
fancify1834983fancify
fancily1538253fancily
fanlike142610503fanlike
fanwise1336633fanwise
fanzine1937123fanzine
farce104925323farc__e
farci105919313farci__
farcical1546953farcical
farcies125317883farcies
farcing133514003farcing
farside1138603farside
fasces114914543fasc_es
fascicled1742993fascicled
fascicles1664263fascicles
fascicule1643063fascicule
fascinated1645873fascinated
fascinates1547153fascinates
fascisms1545663fascisms
fascists1336613fascists
fascitis1346013fascitis
fashing144918793fashing
fashion1337843fashion
fasting114522833fasting
fatlike142911193fatlike
faucal11339963fauc_al
faunae95210373fa_unae
fecial114714623f_ecial
feriae95618603f_eriae
fescue1137493fesc_ue
festive1339773festive
fiscal1139333fisc_al
fissile10269653fissile
fossae95510373fos_sae
francize2246853francize
fusile94313493fus_ile
fustian1036903fustian
jasmine1636643jasmine
laicise939333laicise
laicize1838093laicize
lamiae84817453la_miae
lascar868573lasc_ar
lassie64917743lassi_e
mashie11315933mashi_e
massive12289773massive
miscite11314383miscite
muscae10410673musc_ae
nasial6413283nas_ial
oscine8311563_oscine
pascal10812373pasc_al
paschal14157243paschal
passive12239593passive
pastie85525523pasti_e
pastime114611973pastime
piscinae1285213piscinae
piscine11610973piscine
racial83419243ra_cial
rascal8511123rasc_al
sarcinae1047193sarcinae
taeniae739083taeniae
tassie66017023tassi_e
unciae83215313_unciae
vaccine1437323vaccine
vesicae12177703vesicae

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.1561145455.1
2DLD Change Limit1340271226.64020184.8
3Display Results1221220.0462652.2
 (SQL Overall)1786911226.84226116.8
 
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.