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

130 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
alanyls108435(None) 
alanyl955481alanyl_
adenyls1143922adenyls
alands75418372alan_ds
alanins7315802alanins
alans55636172alan__s
alants67722022alan_ts
alkyls13465722al_kyls
allyls9437272al_lyls
alphyls15113952alphyls
uranyls1034452uranyls
aals49941143a_a__ls
abayas114011703aba_yas
acetyls12285353acetyls
acyls104211523__acyls
adenyl1035023adenyl_
agnails837003agnails
alamos8415003ala_mos
alan46844083alan___
aland65526413alan__d
alane56135613alan__e
alang66023513alan__g
alanin6317273alan_in
alanine7316863alanine
alanines8314803alanines
alant55742293alan__t
alarms85913053ala_rms
alarums9408923alarums
alary86123443alary__
alas46358123ala___s
alaskas1136683alaskas
alates64833963ala_tes
aldols7109713al_dols
aliners74717723aliners
alines65735223alin_es
aliyas93911803al_iyas
aliyos9349533al_iyos
alkanes113812933alkan_es
alkanets12366233alkanets
alkyds14404363al_kyds
alkyl12518043al_kyl_
alkynes14336463alkynes
allays94313743allay_s
alleys95113303alley_s
allonyms1344363allonyms
alloys94014563alloy_s
alls46740923al___ls
allyl85310543al_lyl_
almanacs1254443almanacs
almners9399563almners
alphyl1484083alphyl_
aludels835303aludels
always12409133alway_s
amatols938183amatols
amyls104512693__amyls
anankes1138763anankes
anils56326723__anils
annals66415923a_nnals
annuls64711733a_nnuls
anonyms1235443anonyms
aryls87015813__aryls
asanas6514113asan_as
atabals938413atabals
atlantes838553atlantes
atlatls744773atla_tls
avails939693ava_ils
azans146516883azan__s
balances1279973balances
blandly1336043blandly
blankly1634263blankly
blanks124112893blan_ks
canals84421663_canals
clangs95113613clan_gs
clanks124615183clan_ks
clans75031013clan__s
clays105521333cla_y_s
elands74914773elan_ds
elans55527753elan__s
falafels1453113falafels
flails94313003fla_ils
flanes94522423flan_es
flanges113413273flanges
flanks133913403flan_ks
flannels1134843flannels
flans85327973flan__s
flays116321053fla_y_s
galangals1142903galangals
galangas1046173galangas
glances104113143glances
glandes95413833glandes
glands85314403glan_ds
glans65125833glan__s
glycyls1642063glycyls
halals95018313hala__ls
labels84515683_labels
lalls55324133_la_lls
lanais6316793_lanais
lances84824103_lances
lands65426903_lan_ds
lanely93914483_lanely
lanes54946793_lan_es
lankly13439623_lankly
lapels83712043_lapels
lays76043253_la_y_s
llanos6108333llan_os
malangas1136863malangas
nonyls957853_nonyls
palatals1037773palatals
panels84716523_panels
phenyls1534333phenyls
planers94517943planers
planes85028083plan_es
planets93914083planets
planks124116753plan_ks
plans75731273plan__s
plants84921803plan_ts
planula935773planula
platys11459853platy_s
playas114612283pla_yas
plays106320773pla_y_s
salals65120083sala__ls
slangs75615343slan_gs
slantly10399323slantly
slants64819083slan_ts
slays85723683sla_y_s
stanols739733stanols
ulans54921303ulan__s
uranyl936293uranyl_
valances1398763valances
vinyls12467003_vinyls

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.390458182.1
2DLD Change Limit1340271306.08022043.9
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.51627423.4
 
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.