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

154 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
gametal103760(None) 
acetal84314902_acetal
bimetal1138432bimetal
cameral11311262cameral
gamelan10106642gamelan
gamete9313592gamet_e
gametes10312252gametes
gametic1239982gametic
gomeral1038832gomeral
gunmetal1143212gunmetal
metal75427382__metal
nametag1044442nametag
tapetal938272tapetal
abettal946073_abettal
aceta74017353_aceta_
acetals93411353_acetals
acetyl11396553_acetyl
agamete1037393agamet_e
agametes1147293agametes
agrestal945653agrestal
amatol838683_amatol
ameba9312383_ameba_
amebae1049633_amebae
ameban1039093_ameban
amebas10311453_amebas
amoral8314623_amoral
aortal65217513_aortal
apetaly1237253_apetaly
areal55928733_are_al
artal55525473_a_rtal
bimetals1246943bimetals
caecal103713733ca_ecal
cambial134010763cambial
camel96822803came__l
camera10313673camera_
camerae11312043camerae
cameras11313343cameras
cantal84122033ca_ntal
capital112311523capital
chaetal1238283chaetal
daedal849083da_edal
diametral1243803diametral
faecal11359813fa_ecal
fatal84819373fa__tal
fetal85623373__fetal
foetal9311883_foetal
gaiety10119373gaiet_y
galea64722933gale_a_
galeae74717453gale_ae
galeas74618503gale_as
galeate83916783galeate
galena74911093galena_
galenas83310333galenas
galette84212693galette
galleta8399643galleta_
galletas9308133galletas
gama77035513gam__a_
gamas85431353gam__as
gamay116419103gam__ay
gamba106018513gam_ba_
gambas115817513gam_bas
gambia115912243gambia_
gambias125010733gambias
gambol1138223gam_bol
gambrel1235453gambrel
game76644323game___
gamed95126393game__d
gamelans11115843gamelans
gamely124711913game_ly
gamer84928943game__r
gamers94420823game_rs
games86238553game__s
gamesman1344513gamesman
gamest94919923game_st
gamester1137323gamester
gamey115320553game__y
gamma106116103gam_ma_
gammas115714693gam_mas
gamut8322983gamut__
gamuts958783gamut_s
gastral8329553gastral
gateau778103gate_au
gateman1057463gateman
gateway1434923gateway
gavel95815183gave__l
gavial10310083ga_vial
gayal9312713ga__yal
gayety13116383gayet_y
gazette17357363gazette
geminal10109893geminal
general81010933general
genital849793genital
geta56627443g__eta_
getas65421483g__etas
gimbal11228813gim_bal
gimel8313353gime__l
gimmal11247513gim_mal
glottal835103glottal
gluteal854243gluteal
gomerals1147443gomerals
gomerel1036393gomerel
gomeril1047383gomeril
gremial1039153gremial
gunmetals1242903gunmetals
haemal113811643ha_emal
haematal1345143haematal
hamal104623103ham__al
hammal134512063ham_mal
hartal9415473ha_rtal
hematal1238953hematal
humeral1238563humeral
hyetal1236543_hyetal
hymenal1545183hymenal
lacteal966813lacteal
lamella988603lamella
laminal94113633laminal
lanital7310913lanital
lateral7313563lateral
lumenal9307273lumenal
mammal95112753mam_mal
marital92314183marital
meal65643173__me_al
meatal84114733__meatal
medal86221323__medal
mental84521603__mental
meta65932413__meta_
metals84520883__metals
metol75917813__metol
nametags1143093nametags
natal53921493na__tal
nonmetal1049633nonmetal
numeral939083numeral
oatmeal944973oatme_al
omental93210413_omental
palatal9310153palatal
paleal84716673pale_al
parental10310943parental
parietal1048773parietal
petal76526893__petal
ramal74622243ram__al
ramenta9311183ramenta_
ramet75743143ramet__
ramets83517393ramet_s
ramtil8311023ram_til
ratal55025113ra__tal
sambal105215183sam_bal
segetal868383segetal
setal56430903__setal
somital939403somital
tamal73522613tam__al
tapeta8310693tapeta_
varietal1145613varietal
vegetal1156303vegetal
wameful1535673wameful

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271545.70323501.1
3Display Results1541540.0463347.8
 (SQL Overall)1786911545.90530261.0
 
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.