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

176 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
somital93940(None) 
coital84117052co_ital
comical13312222comical
comitial1248692comitial
domical1239372domical
nominal92712372nominal
seminal91213402seminal
simitar936732simitar
social8813332soci_al
societal1045722societal
somata8312382somata_
somite84519372somit_e
somites94219122somites
somitic111512632somitic
spital83813872s_pital
stomatal1045832stomatal
summital1244702summital
admiral1046363admiral
aortal65217513ao_rtal
asocial998653asoci_al
astomatal1144983astomatal
atomical1248903atomical
bimetal1138433bimetal
bonita8312943bonita_
bonitas939453bonitas
borstal939043borstal
capital112311523capital
chital114313883_chital
coastal9411043coastal
comal95125133com__al
comitia1139723comitia
comity13312713comit_y
committal1543723committal
conical11316203conical
cosmical1448013cosmical
costal85419513co_stal
cotidal1038463cotidal
cubital1137103cubital
digital937063digital
domal85619203dom__al
domicil1246433domicil
dotal64919623do__tal
foetal9311883fo_etal
fomite113314073fomit_e
fomites123613203fomites
fontal9313143fo_ntal
gametal1037603gametal
geminal10109903geminal
genital849793genital
gnomical1346683gnomical
gomeral1038833gomeral
hematal1238953hematal
hospital1344743hospital
invital1046953invital
jovial1636543jovi_al
laminal94113633laminal
lanital7310913lanital
liminal93810673liminal
logical1038513logical
luminal93711003luminal
marital92314183marital
metal75427383__metal
mimical1339233mimical
mitral81314323__mitral
mortal84616853mo_rtal
nodical1049863nodical
nomina83113683nomina_
nominals10278613nominals
nonmetal1049643nonmetal
nonvital1147023nonvital
notal55221353no__tal
octal71214723_o_ctal
ogival1035873_ogival
omental93210413_omental
omit65337373_omit__
omits75018263_omit_s
oomiac1037063oomi_ac
oomiak1235353oomi_ak
orbital936923orbital
osmolal944393osmolal
portal84218463po_rtal
postal84317533po_stal
recital9412163recital
remittal1046513remittal
ruminal9289993ruminal
sagittal943283sagittal
sahiwal1344443sahiwal
sambal105215183sam_bal
samiel8313333sami_el
samite83020603samit_e
samites93118713samites
scimitar1243593scimitar
scribal1137963scribal
scrotal938493scrotal
segetal868383segetal
seitan62613233s_eitan
semibald1344563semibald
semigala1144633semigala
semimat11412903semimat
semimetal1345753semimetal
semina8915563semina_
seminar979753seminar
semioval1346223semioval
semiraw1246053semiraw
semitonal1157043semitonal
septal84513383s_eptal
serial64625863seri_al
setal56430903s__etal
shaitan1036893shaitan
sheitan1036573sheitan
sial45938833s__i_al
simian8811163simi_an
similar937853similar
simitars1046483simitars
sisal54217733s__isal
sitar54820543s__itar
smilax1535393s_milax
smit65138413s_mit__
smite75224873s_mit_e
smiter83616413s_miter
smites83921923s_mites
smith107818053s_mit_h
smiths114711023s_miths
smithy14508273s_mithy
socials999633soci_als
softa86415183so_fta_
softas94410403so_ftas
soil46138833so_i__l
solitary1146503solitary
soliton7410233soliton
soma65635293som__a_
soman75024903som__an
somas76030373som__as
somatic111916463somatic
someday1345883someday
somedeal1144573somedeal
someway1545613someway
sonantal886263sonantal
sonata6313223sonata_
sonatas7510293sonatas
sopite84917713sopit_e
sopited104211063sopited
sopites93817173sopites
sorbitol1043743sorbitol
sorites73825243sorites
soritic91414433soritic
sororal7310653sororal
sorta57125413so_rta_
sotol54917653so__tol
spatial9310323spatial
spinal84915313s_pinal
spiral83715343s_piral
spitals93011593s_pitals
staminal1046983staminal
statal61613223s_tatal
stoical9310283stoical
stomal85213313stom__al
stomata938533stomata_
stratal72710603stratal
submittal1343883submittal
tombal102311023tom_bal
topical1139953topical
total55321823to__tal
toxical1637643toxical
viminal12288823viminal
vital84819673__vital
vomica1336383vomica_
vomicae1445303vomicae
vomit102622573vomit__
vomited1337253vomited
vomiter1237953vomiter
vomito11238033vomit_o
vomitos12217103vomitos
vomits112610923vomit_s
vomitus12215743vomitus
zooidal1745093zooidal

Search took 8 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 Limit1340271767.00019146.7
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.21924752.9
 
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.