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

115 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
amentias103940(None) 
amentia9310151amentia_
agential958152agential
amanitas1048522amanitas
amenities11310412amenities
aments85219802ament__s
amnesias1047822amnesias
dementias1257402dementias
abelias93213563abe_lias
acedias1039763ace_dias
acequias1943963acequias
acetins9313173ace_tins
adenitis947433adenitis
adenoids1056843adenoids
adenomas1144813adenomas
agencies1138743agencies
agendas936933agen_das
agenesias1045363agenesias
agenting1039383agenting
agentings1134443agentings
agentival1353663agentival
agentive1248043agentive
agentives1346443agentives
agentries1048233agentries
agents74816293agent__s
alexias14249793ale_xias
amanita9310453amanita_
amanitins1147123amanitins
amebas10311453ame__bas
amenders11288343amenders
amending12308913amending
amends94713283amen__ds
amenity1238333amen_ity
amens75624843amen___s
ament76036543ament___
amias75831473am___ias
aminities11312883aminities
amities9317383am_ities
ammonias1247943ammonias
amnesia938293amnesia_
amnesiac1265073amnesiac
amnesiacs1353243amnesiacs
amnesics1255283amnesics
amnesties1166873amnesties
amnia75918643am_n_ia_
amnios84912523am_n_ios
amreetas1044273amreet_as
amritas939093amrit_as
amusias938573am_usias
anemias92512143ane_mias
anergias947173anergias
antas55432033a__nt_as
antiar6317173a__ntiar
antiars7314623a__ntiars
antics84621453a__ntics
antis55033313a__nti_s
arenas65021993aren__as
arenites8917103arenites
atonias73315993aton_ias
aunties73920073a_unties
aventail1145343aventail
aventails1244993aventails
cadential1246383cadential
camelias12510293came_lias
camellias1365073camellias
centas85020703_cent_as
dementia1157823dementia_
demential1248683demential
dentils84115583_dentils
dentins83419223_dentins
emeritas1046433emeritas
emetics11610723eme_tics
emetins9812643eme_tins
entia5318203__entia_
gentian8310103_gentian
gentians937563_gentians
hamartias14115353hamartias
inertias8410383inertias
lamenters1137683lamenters
lamenting1237693lamenting
laments94314853lament__s
lentils73912973_lentils
magentas1137923magent_as
manias84029033_man_ias
mantas85725363_mant_as
mantids103113623_mantids
mantis83926033_manti_s
mantras93815863_mantras
mantuas93410993_mantuas
medias93620783_me_dias
menhirs1235913_menhirs
menial84223033_men_ial
menials94015683_men_ials
mensas85115853_men_sas
menta74424423_ment_a_
mental84521603_ment_al
mentees93214503_mentees
mention9314373_mention
mentions10312893_mentions
mentors9314993_mentors
mestizas1944693_mestizas
metis75025903_me_ti_s
muntins92715133_muntins
omenta83411723oment_a_
omental93210413oment_al
omentums1243973omentums
opuntias10103233opuntias
plenties10314693plenties
ramenta9311183rament_a_
taenias7311283taen_ias
tenias64720073_ten_ias
twenties1137503twenties
valencias1443633valencias
xenias133712973_xen_ias
yentas94614213_yent_as

Search took 10 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 Filter1786911461620.186960704.3
2DLD Change Limit1461621159.09316074.1
3Display Results1151150.0631825.4
 (SQL Overall)1786911159.34219127.7
 
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.