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

117 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
aliner6562198(None) 
aliener71011191aliener
aligner8108301aligner
aline57243151aline_
alined75221401alined
aliners74717721aliners
alines65735221alines
almner85710721almner
liner55938911_liner
abider95314462abider
acinar8310482acinar
aginner844662aginner
aider65431132a_ider
aimer75926822a_imer
airer54927892a_irer
airliner836952airliner
aiver85725162a_iver
alane56135612alane_
alder65421912al_der
alien56425582ali_en
aliened81011742aliened
alienee71013152alienee
alieners889822alieners
alienor7116302alienor
aliens65619212aliens
aligned9128552aligned
aligners9117562aligners
alike95523962alike_
aliped95414282aliped
alive85722512alive_
alkine104916802alkine_
alkines114415732alkines
almners9399562almners
almoner949382almoner
alone55732962alone_
alpine84417372alpine_
alpines94016192alpines
alter54828502al_ter
alvine94614582alvine_
amine75835372amine_
amines84727982amines
arider74717742arider
atoner64817192atoner
azine146721412azine_
azines155517072azines
biner75930692_biner
blinder103912982blinder
blinker134110212blinker
briner84519042briner
byliner1235722byliner
caliber1139732caliber
caliper11410962caliper
cline76428532cline_
clines84926042clines
clinger103812142clinger
clinker133811662clinker
cloner84418092cloner
coiner84323782coiner
diner65632902_diner
eloiner7149182eloiner
fainer94717242fainer
finer85431562_finer
flier86023402fli_er
flinder11319872flinder
flinger113710502flinger
gainer74117492gainer
glider84614262glider
joiner134114132joiner
lanner64920592lanner
liber74723612_liber
lier45942462_li_er
lifer85822152_lifer
liger65024462_liger
liker95627062_liker
limner84112862_limner
line46965572_line_
linear65113332_linear
lined64934642_lined
linen55728722_linen
liners65428842_liners
lines57054572_lines
liney87029622_liney
linger75225992_linger
linier64423782_linier
linker104321462_linker
linter64625332_linter
liter54736342_liter
liver85132962_liver
loner55431032_loner
maligner11115332maligner
maline84529082maline_
malines93625602malines
malinger11116532malinger
mariner93315992mariner
miner76933542_miner
palier85023562pali_er
plainer93811982plainer
planer84122652planer
plier75221282pli_er
plinker134010962plinker
ruiner64013642ruiner
saline65132702saline_
salines74029412salines
seiner64622482seiner
shiner93820872shiner
slicer84117602slicer
slider73918362slider
slier54827242sli_er
slinger83413822slinger
sliver94116592sliver
twiner94012592twiner
vainer93714572vainer
valine94623092valine_
valines104520212valines
veiner94514752veiner
weiner94214132weiner
whiner124516632whiner

Search took 4 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 Filter178691825510.1061685764.2
2DLD Change Limit825511173.04627101.4
3Display Results1171170.0333545.5
 (SQL Overall)1786911173.18556103.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.