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

118 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
anomaly123884(None) 
animacy1446102animacy
animal85016252animal_
animally1368642animally
animals94111702animals
anodal72512122anodal_
anodally1246292anodally
anomy105113392anom__y
abnormal1244093abnormal_
abnormally1752743abnormally
abnormals1342773abnormals
aboma91114603aboma__
abomas101113583aboma_s
abomasa11114613abomasa
abomasi11115493abomasi
aboral8314373aboral_
aborally1347063aborally
adorably1446443adorably
agonal7410053agonal_
aloofly1343623aloofly
amoral8314633amoral_
amorally1348093amorally
amply125012913a__mply
anal48037523an__al_
anally9513503an_ally
anconal939423anconal_
angary10311323an_gary
angerly1137773angerly
angrily1137723angrily
anima74620073anima__
animalic1258153animalic
animality1447803animality
animas84418723anima_s
animate91617213animate
animately1445123animately
animato91610623animato
annal56520763an_nal_
annals66415923an_nals
anneal64812303anneal_
anneals7449953anneals
annual64710703annual_
annually1145833annually
annuals7388193annuals
anoa45634473ano_a__
anoas57226493ano_a_s
anole55330383ano__le
anomalies1149283anomalies
anomalous1145193anomalous
anomic102516303anom_ic
anomie83215963anom_ie
anomies93316993anomies
anorak1038923anora_k
anoraks1137603anoraks
anorexy1743563anorexy
anticly12410053anticly
antimale10312463antimale
antral65719413antral_
anural65714743anural_
anyway1534803anywa_y
apetaly1237253apetaly
apnoeal956193apnoeal_
apodal9289833apodal_
apogamy1543623apogamy
aroma71220143aroma__
aromas81018613aroma_s
atomy107415193atom__y
atonal6514023atonal_
atonally1148633atonally
avowably1944003avowably
avowal1246323avowal_
avowals1335013avowals
axonal1347653axonal_
azonal1568273azonal_
bromal10313653bromal_
bromals1139743bromals
coaly105521593_co_aly
comal95125133_comal_
comely134213733_comely
comply152810383_comply
domal85619203_domal_
doomily1336133doomily
homely145313183_homely
homily144712333_homily
knobbly1842873knobbly
knolly13336133kno_lly
namely113711323_namely
nimbly13388773_nimbly
nobly105314403_no_bly
nodal64717793_nodal_
nodally1137913_nodally
noily86120993_no_ily
noma67529463_noma__
nomad86016183_noma_d
nomads94711603_nomads
nomas74726413_noma_s
nopal75517103_nopal_
nopals84914023_nopals
normal83213533_normal_
normalcy1543383_normalcy
normally1347883_normally
normals92510903_normals
nosily93712683_nosily
notably12199993_notably
notal55221353_notal_
notary92310713_notary
noway111112843_nowa_y
numbly134410663_numbly
panoply1434713pano_ply
randomly1443793random_ly
roomily1237283roomily
shoaly124010773sho_aly
snowily1336883snowily
stomal85213313stomal_
uncomely1545363uncomely
unmanly1236993un_manly
unwomanly1752683unwomanly
womanly1535853_womanly
yeomanly1643213yeomanly

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.440406115.9
2DLD Change Limit1340271187.23318529.9
3Display Results1181180.0333575.8
 (SQL Overall)1786911187.70623188.6
 
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.