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

164 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
omental9321041(None) 
mental84521601_mental
omenta83411721omenta_
cental84420962_cental
dental74319172_dental
lomenta92710132lomenta_
meatal84114732_meatal
menial84223032_menial
mensal84615662_mensal
menta74424422_menta_
metal75427382_me_tal
momenta11299852momenta_
nonmental11410852nonmental
omentum1155932omentum
oriental848482oriental
rental63922022_rental
tomenta9319832tomenta_
abettal946073abettal
acetal84314903ace_tal
agential958153agential
alimental1155863alimental
ament76036543ament__
amentia9310153amentia
amentias1039413amentias
aments85219803ament_s
argental947933argental
aventail1145343aventail
benthal1247953_benthal
benzal1739643_benzal
bidental1146583bidental
bimensal1244103bimensal
bimetal1138433bime_tal
cantal84122033_cantal
cementa112810543cementa_
centai84814783_centai
centals94317053_centals
centas85020703_centas
central93114473_central
cliental1045353cliental
commensal1546013commensal
crestal9312133crestal
demential1248693demential
denial74720513_denial
dentals83915393_dentals
dentil74017883_dentil
documental1554513documental
elemental1145883elemental
entail61114343__entail
eventual1144883eventual
festal94213563_festal
fetal85623373_fe_tal
foetal9311883foe_tal
foment113718303foment__
fomented1437803fomented
fomenter1339263fomenter
foments122912053foment_s
fontal9313143_fontal
forestal11410283forestal
frontal1038363frontal
gametal1037603game_tal
genial74917613_genial
genital849793_genital
gentil74115123_gentil
gomeral1038833gome_ral
hematal1238953hematal
homestay1645813homestay
hyetal1236543hye_tal
hymenal1545183hymen_al
hymeneal1643473hymeneal
hymenial1645293hymenial
lentil64315393_lentil
lienal63912783lien_al
loment84021473loment__
loments93413473loment_s
lomentum1244753lomentum
lumenal9307273lumen_al
manta75629913_manta_
mantas85725363_mantas
mantel84317973_mantel
manual8313463_manual
meal65643173_me__al
medal86221333_me_dal
medial93819863_medial
menad85918983_men_ad
menials94015683_menials
mensa75318673_mensa_
mensae84114053_mensae
mensas85115863_mensas
mentally131010403_mentally
mentee84121293_mentee
menthol1236723_menthol
mentor8414363_mentor
mentum104511713_mentum
mescal104113493_mescal
mesial84818083_mesial
meta65932413_me_ta_
metals84520883_me_tals
metol75917813_me_tol
mezcal19367853_mezcal
moment103319683moment__
momentary1645233momentary
momently1546473momently
momento11348903moment_o
momentos12338333momentos
moments113113123moment_s
momentum1144433momentum
monumental1455213monumental
mortal84616853_mortal
nominal92712373nomin_al
nonmetal1049643nonme_tal
noumenal1046173noumen_al
obento837893obent_o
obentos936703obentos
octal71214723o__ctal
octantal1044563octantal
omega836383ome_ga_
omegas936973ome_gas
omen66828183omen___
omened93711003omen_ed
omening10310093omening
omens75618963omen__s
omentums1243973omentums
orbital936923orbital
orientals946903orientals
ornamental1264643ornamental
overtalk1537073overtalk
overtax17257733overtax
parental10310943parental
penal75228373_pen_al
penial84120893_penial
pentad9313763_pentad
pentyl1138813_pentyl
petal76526893_pe_tal
polenta9310093polenta_
polentas1038743polentas
potential1148533potential
prenatal1048373prenatal
quantal16367893quantal
quintal16389883quintal
ramenta9311183ramenta_
rectal84418133_rectal
regental948943regental
renal55929503_ren_al
rentals74017473_rentals
segmental1265993segmental
sendal73314993_sendal
septal84513383_septal
setal56430903_se_tal
somedeal1144573somedeal
somital939403som_ital
sonantal886263sonantal
tectal83713253_tectal
tegmental1275393tegmental
thenal92712423then_al
tomentum1244993tomentum
tormentil1144223tormentil
venal85523213_ven_al
venial94218283_venial
ventail10310453_ventail
ventral103612173_ventral
vestal94615573_vestal
xenial133414903_xenial
yenta83917043_yenta_
yentas94614213_yentas

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.403443402.0
2DLD Change Limit1340271646.06322105.7
3Display Results1641640.0463565.2
 (SQL Overall)1786911646.51227440.3
 
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.