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

123 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
fermata1227814(None) 
fermatas13246221fermatas
fermate122813001fermate
bemata10411692be_mata
errata639012_errata
ferrate103014042ferrate
format113021352format_
formate123115092formate
formats123113572formats
lemmata1144672lemmata
regmata1036192regmata
aerate64830553aer_ate
aftermath1743673aftermath
armada938783_armada
bedmate1239433bedmate
berate84729023ber_ate
beretta938463beretta
bregmata1343203bregmata
celomata1296623celomata
cerate84829463cer_ate
cermet10321153cermet_
cermets1139713cermets
commata1338483commata
cremate113816183cremate
derat65044083der_at_
derate74531233der_ate
derats74625063der_ats
derma84918513derm__a
dermal93614343derma_l
dermas94116813derma_s
dogmata1145143dogmata
edemata1046003edemata
enemata948013enemata
ergate7315143_ergate
erratas736863_erratas
ersatz1536653_ersatz
feat76458223fe__at_
feats86432753fe__ats
fellate10313433fellate
female11310553fe_male
femora1149583fe_mora
feral85424653fer_a_l
ferals94216643fer_als
ferbam1339003ferba_m
ferbams1435743ferbams
feria85922713fer__ia
feriae95618603feria_e
ferial94621253feria_l
ferias95020393feria_s
ferity122813343fer_ity
ferment12315573ferment
ferments13311473ferments
fermi103914163ferm__i
fermion1236763fermion
fermis114313503ferm_is
fermium1446353fermium
ferrates113013423ferrates
ferret93021173ferret_
ferrets103111393ferrets
ferrety13287013ferrety
ferrite103312753ferrite
ferula93011173fer_ula
feta76528903fe___ta
fibromata1673783fibromata
firman112211343firma_n
firmans12238523firmans
forgat104018583forgat_
formal113215203forma_l
formals123312893formals
formant123416003formant
formants13269953formants
formates132814293formates
formica1436443formica
formula1246293formula
frat75648543f_r_at_
frats86829673f_r_ats
frusta937453f_rusta
furcate12310453furcate
furmety1534813furmety
furmity1535183furmity
gemmate12418383gemmate
german9611983germa_n
germane1049663germane
germans1079473germans
germina1038493germina
gummata1244613gummata
hematal1238953he_matal
hereat93527413hereat_
herma105318883herm__a
hermae115314473herma_e
hermaean1343603hermaean
hermai118912863herma_i
hermit11519443hermit_
hermits12312143hermits
kerygmata1951313kerygmata
magmata1237463magmata
mermaid1297853mermaid
merman10513863merma_n
myomata1445923myomata
nervate1039523nervate
neuromata1145143neuromata
oedemata1143853oedemata
permeate12311613permeate
permit10321683permit_
permits11314003permits
permute1138793permute
reata54225393__reata
remate84428683re_mate
riata54618023__riata
serenata8197673serenata
seriate73722473seriate
serrate73017543serrate
somata8312383_somata
spermatia1346743spermatia
stemmata1244213stemmata
stomata938533stomata
strata63616283str_ata
striata7379953striata
stromata1047593stromata
termite9313893termite
ternate7415483ternate
trymata1244223trymata
vermuth1543533vermuth

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 Limit1340271236.09321996.9
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.29528386.2
 
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.