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

110 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
admiral104636(None) 
admirals1144351admirals
achiral12109182achiral
admirable1445432admirable
admirably1743882admirably
admiralty1552242admiralty
admire949932admir_e
admired1135702admired
admirer1035522admirer
admires1038662admires
adumbral1342342adumbral
amoral8314632a_moral
nadiral836342nad_iral
abdominal1453063abdominal
aboral8314373a_boral
actinal9312293actinal
adagial946373adagial
adaxial1545323adaxial
adman84517913adm__an
admirers1134713admirers
admiring1236133admiring
admit8319493admi__t
admits9411413admi_ts
admix1557733admi__x
admixed1833733admixed
admixes1765963admixes
admixt1637333admi_xt
adnexal1543823adnexal
adrenal838263adrenal
aecial84817313aeci_al
aerial64625713aeri_al
affinal1336443affinal
affixal2043763affixal
albinal937813albinal
amia66836903a_mi_a_
amias75831473a_mi_as
amidol9489573a_midol
amiga85514813a_miga_
amigas95912173a_migas
amir65129753a_mir__
amirate91115953a_mirate
amirs75924923a_mir_s
ammonal1137023ammonal
amtrac10109133a_mtrac
anginal8310163anginal
animal85016253a_nimal
antral65719413a_ntral
anural65714743a_nural
apical10913903a_pical
apsidal1046703apsidal
apteral9311523apteral
arbitral1045423arbitral
armigeral1252453armigeral
armilla936993armilla
armorial1049453armorial
arrival1037563arrival
astral66919283a_stral
aswirl935093aswir_l
atomical1248903atomical
atrial65418943atri_al
audial7312993audi_al
augural856403augural
aural54428963a__ural
auroral7310473auroral
austral73411513austral
awhirl1264673awhir_l
axial124515193a_xi_al
balmoral1244633balmoral
cameral11311283cameral
chiral114614413_chiral
comical13312223comical
datival1135583datival
dial55935073_d_i_al
diram84419473_d_iram
dirl57430033_d_ir_l
domical1239373domical
dural64923893_d_ural
femoral1238723femoral
geminal10109913geminal
gomeral1038843gomeral
humeral1238573humeral
humoral1237983humoral
immoral1146783immoral
laminal94113633laminal
liminal93810673liminal
luminal93711003luminal
madeira1045113madeira_
madeiras1144773madeiras
madrigal121627263madrigal
mimical1339233mimical
mitral81314323__mitral
moral75533433__moral
mural75225113__mural
nominal92712373nominal
numeral939083numeral
radial74020393rad_i_al
radical103312793rad_ical
ruminal9289993ruminal
seminal91213413seminal
semiraw1246053semiraw
somital939403somital
spiral83715343_spiral
timbral11237193timbral
tumoral938133tumoral
umbral1038633_umbral
unmoral948693unmoral
viminal12288823viminal
viral86419593__viral
wadmaal1343203wadm_aal
wadmal1237293wadm__al

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.406440125.6
2DLD Change Limit1340271106.51620568.9
3Display Results1101100.0303666.7
 (SQL Overall)1786911106.95225703.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.