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

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

88 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
leporine104930(None) 
lemurine1046522lemurine
leonine7311232le_onine
leporid1048152lepori_d
leporidae1252982leporidae
leporids1145672leporids
apocrine1246933_apocrine
caprine11314233cap_rine
chlorine133013303chlorine
chorine123218363_chorine
deploring1337853deploring
depone93616553depo__ne
deponing121211213deponing
deportee11510353deportee
deporting1369593deporting
deposing12129773deposing
deprive1338303dep_rive
dextrine1688253dextrine
eccrine1137283_eccrine
eosine64519413_e_osine
epergne1046143_epergne
epoxide1745343_epoxide
eserine7415903_eserine
exocrine1745993_exocrine
ferine96422583fe__rine
fluorine1147813fluorine
heparin12410433heparin_
heparins13310123heparins
heroine103517483hero_ine
kerosine1238143kerosine
laboring112110143laboring
laborite10410693laborite
lanoline8311953lanoline
larine63927043l__arine
latrine7715123l_atrine
leering83417643le_ering
legatine91311403legatine
leone55018823le_o__ne
leprose938543lep_rose
leptin82512333lep_tin_
leptins92412693lep_tins
leptotene1143533leptotene
leucine938073le_ucine
levering122212503levering
licorice1246133licorice
ligroine945693ligroine
loriner7511893l__oriner
lupine84013533lup__ine
memorise121411433memorise
memorize211311103memorize
merocrine1346233merocrine
neoprene1045173neoprene
nephrite1346713nephrite
neurine7311683ne_urine
papyrine1546053papyrine
pecorini1246553pecorini
pecorino1246633pecorino
pelerine10313013pelerine
pemoline12310273pemoline
pepsine11310603pep_sine
piperine122011833piperine
porcine11312843__porcine
poring94227273__poring
purine85321893__purine
reboring11312783reboring
repine85627813rep__ine
reporting12513903reporting
reposing111213803reposing
repouring12310073repouring
reprice113212833rep_rice
reprint9318983rep_rint
reprise92715043rep_rise
saponine1039223saponine
sepaline10311343sepaline
serine65432673se__rine
serotine8313573serotine
sporing104319413_sporing
taborine102510683taborine
temporise1347403temporise
temporize2246873temporize
tenorite8311993tenorite
tephrite1346593tephrite
terrine72517573te_rrine
vaporing1437653vaporing
vaporise13209633vaporise
vaporize22239173vaporize
viperine13189713viperine
zebrine1836463ze_brine

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit146162887.23320207.7
3Display Results88880.0302933.3
 (SQL Overall)178691887.68623248.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.