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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
align6501650(None) 
algin65718761algin
alien56425581alien
aligns75312951aligns
malign939851malign
acing87429152acing
agin56132712agi_n
aging77026352aging
ahing98928352ahing
ailing74331012ailing
ain37579092a_i_n
airn46433832a_irn
akin86328032aki_n
alan46844082al_an
alang66023512alang
alga57927602al_ga
algid75415582algid
algins74816432algins
alias55834602alias
alibi7514232alibi
aliens65619212aliens
alif76242142ali_f
alifs86121262alifs
alight103816862alight
aligned9128552aligned
aligner8108312aligner
alike95523962alike
aline57243152aline
alist56136782alist
alit46155692ali_t
alive85722512alive
aliya83713482aliya
aloin55227422aloin
along65419492along
amiga85514812amiga
amigo86515472amigo
amin66042252ami_n
anion55028812anion
apian75018332apian
aping87327232aping
assign736782assign
avian84616052avian
avion84218342avion
awing96827322awing
axing138521372axing
axion1211316912axion
ayin76331742ayi_n
baling94829692baling
blin67228172bli_n
cling86424672cling
coign85013912coign
deign74312802deign
eloign7456982eloign
feign94210712feign
fling97023512fling
haling104229782haling
kalian10312162kalian
laigh95515922laigh
lain46146282lai_n
lien45339802_lien
ligan67920282_ligan
limn66527692_limn
lin37967372_li_n
ling57447962_ling
linn46034592_linn
lion46334442_lion
maligns1038132maligns
paling93530132paling
realign838762realign
reign65015192reign
sign55523052_sign
sling66028802sling
talion6317712talion
waling104525302waling

Search took 3 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.343520965.0
2DLD Change Limit53800741.70331591.3
3Display Results74740.0332242.4
 (SQL Overall)178691742.07985950.5
 
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.