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 “feline” 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
feline9482014(None) 
felines104718071felines
ferine96422581ferine
reline65434351reline
aedine73218392aedine
aline57243152_aline
beeline93314722beeline
belie75630382beli_e
belike124616282belike
belive115415302belive
berline93716852berline
byline11311642byline
cline76428532_cline
decline103716612decline
define104718142define
delaine8314792delaine
delime9314042delime
elide64922642_elide
elint55436472_elint
elite56230182_elite
exine125518492_exine
famine114318192famine
feeing104416502feeing
feeling113617072feeling
feint84732252fe_int
felid94717172feli_d
felids103111622felids
felinely1445942felinely
felling113321132felling
felloe93513922felloe
felon84619292felon_
felons93615762felons
felony123710322felony
felsite1039082felsite
felting113515212felting
feminie12179932feminie
feriae95618602feriae
ferlie92814052ferli_e
feting104417792feting
feuing104412272feuing
filing103823762filing
fine75147952f__ine
fling97023512f_ling
flint87333502f_lint
flite85424962f_lite
fueling113615132fueling
fulmine1257962fulmine
hemline12311072hemline
lifeline11167662lifeline
line46965572__line
maline84529082maline
moline84422032moline
myeline1238252myeline
offline1345782offline
oleine6313792oleine
online6315842online
pelite84323002pelite
recline94020492recline
redline84218832redline
refine95225692refine
relined85321932relined
relines75331322relines
relink104415922relink
relive95120782relive
repine85627812repine
retine66237332retine
rexine134719442rexine
saline65132702saline
seine55732872se_ine
serine65432672serine
setline7313922setline
spline86020532spline
valine94623092valine
venine93718432venine

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 Filter178691825510.1101624463.6
2DLD Change Limit82551742.33035429.6
3Display Results74740.0135692.3
 (SQL Overall)178691742.45372845.9
 
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.