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
amentias103941(None) 
amentia9310151amentia_
agential958152agential
amanitas1048532amanitas
amenities11310432amenities
aments85219802ament__s
amnesias1047832amnesias
dementias1257412dementias
abelias93213563abe_lias
acedias1039773ace_dias
acequias1943973acequias
acetins9313173ace_tins
adenitis947433adenitis
adenoids1056863adenoids
adenomas1144813adenomas
agencies1138743agencies
agendas936933agen_das
agenesias1045363agenesias
agenting1039383agenting
agentings1134443agentings
agentival1353663agentival
agentive1248043agentive
agentives1346443agentives
agentries1048233agentries
agents74816293agent__s
alexias14249793ale_xias
amanita9310453amanita_
amanitins1147133amanitins
amebas10311453ame__bas
amenders11288353amenders
amending12308913amending
amends94713283amen__ds
amenity1238333amen_ity
amens75624843amen___s
ament76036543ament___
amias75831473am___ias
aminities11312913aminities
amities9317383am_ities
ammonias1247953ammonias
amnesia938293amnesia_
amnesiac1265073amnesiac
amnesiacs1353243amnesiacs
amnesics1255283amnesics
amnesties1166873amnesties
amnia75918643am_n_ia_
amnios84912523am_n_ios
amreetas1044273amreet_as
amritas939093amrit_as
amusias938583am_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
cadential1246393cadential
camelias12510303came_lias
camellias1365093camellias
centas85020703_cent_as
dementia1157833dementia_
demential1248693demential
dentils84115583_dentils
dentins83419223_dentins
emeritas1046433emeritas
emetics11610723eme_tics
emetins9812653eme_tins
entia5318203__entia_
gentian8310103_gentian
gentians937563_gentians
hamartias14115363hamartias
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
menials94015693_men_ials
mensas85115863_men_sas
menta74424423_ment_a_
mental84521603_ment_al
mentees93214503_mentees
mention9314373_mention
mentions10312893_mentions
mentors9314993_mentors
mestizas1944703_mestizas
metis75025903_me_ti_s
muntins92715133_muntins
omenta83411723oment_a_
omental93210423oment_al
omentums1243973omentums
opuntias10103233opuntias
plenties10314693plenties
ramenta9311183rament_a_
taenias7311283taen_ias
tenias64720073_ten_ias
twenties1137503twenties
valencias1443633valencias
xenias133712973_xen_ias
yentas94614213_yent_as

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621157.18620339.8
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.70223200.6
 
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.