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 “alant” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

129 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
alant5574229(None) 
alan46844081alan_
aland65526411aland
alane56135611alane
alang66023511alang
alans55636171alans
alants67722021alants
aslant6317751aslant
avant86224661avant
plant75437111plant
slant55238701slant
abaft10318062abaft
ablaut8313262ablaut
adapt81218552adapt
agent65829642agent
ala312463602ala__
alack114820062alack
alae45643752ala_e
alamo7418142alamo
alands75418372alands
alanin6317272alanin
alanyl955482alanyl
alar46340072ala_r
alarm76621422alarm
alary86123442alary
alas46358122ala_s
alate55340322alate
alert54740652alert
aline57243152aline
alist56136782alist
alit46155692al_it
alkane104313322alkane
alkanet113714432alkanet
allot54933872allot
aloft8423432aloft
alone55732962alone
along65419492along
alt36467962al__t
ament76036542ament
anent54931842anent
ant37270792__ant
apart74330672apart
arrant6623252arrant
asana5315482asana
askant10412712askant
aunt46553652a_unt
avast85519362avast
avaunt959602avaunt
await85524492await
azan136521782azan_
azans146516882azans
bland85320452bland
blank115418552blank
blast76532572blast
blat66550952bla_t
blent76230952blent
blunt75525022blunt
brant74742172brant
callant94121222callant
cant66362032_cant
chant105932692chant
clan65633922clan_
clang86019312clang
clank114719522clank
clans75031012clans
clapt98027172clapt
clast76030582clast
elan46734242elan_
eland65820392eland
elans55527752elans
elint55436472elint
eluant6315092eluant
flan76134182flan_
flank124618092flank
flans85327972flans
flat77147822fla_t
flaunt9712912flaunt
flint87333502flint
gallant83517112gallant
gelant72821672gelant
giant65430592giant
gland75217712gland
glans65125832glans
glint66830182glint
grant64840022grant
hant75461592_hant
land56337312_land
lane45153332_lane
lang56637382_lang
lank84734452_lank
last46260322_last
lat37593402_la_t
leant56737782leant
lent46360532_lent
lint416266232_lint
llano5910602llano
lunt46148842_lunt
meant76537212meant
natant6318732natant
pant66061262_pant
plaint85323202plaint
plait75631572plait
plan65833942plan_
plane74929142plane
planet84228352planet
plank115221142plank
plans75731272plans
plants84921802plants
plat66048872pla_t
pliant83918822pliant
quant143624812quant
rant45864682_rant
riant55833152riant
saltant7316772saltant
savant9416042savant
scant79735072scant
sealant73118302sealant
slang66324022slang
slank95822772slank
slants64819082slants
slanty95114842slanty
slat46959022sla_t
talent6323322talent
ulan46527392ulan_
ulans54921302ulans
vacant11415132vacant
valiant10314622valiant
volant9316322volant
want76156172_want

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001291.59333772.8
3Display Results1291290.0304300.0
 (SQL Overall)1786911291.93692299.1
 
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.