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

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

51 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
meperidines165310(None) 
meperidine1553751meperidine_
piperidines1653252piperidines
hesperidins1772783hesperidin_s
piperidine1553793piperidine_
pteridines1345463_pteridines
pyridines1546473__pyridines
acridines1247724__acridines
asperities1249764asperiti_es
benzidines2242704be_nzidines
celerities1289774celeriti_es
cimetidines1652304cimetidines
determines1358434deter_mines
emperies12314564emper__i_es
epergnes1156714_eper__gnes
epoxidizes2952664_epoxidizes
eserines8413744_eser__ines
gaberdines1443624gaber_dines
hesperidin1672944hesperidin__
heterodynes18134164heterodynes
legerities1196884legeriti_es
meclizines2342364me_clizines
medicines1447904m__edicines
mephitises1744614mep_hitises
meridians1245544m__eridians
metricizes2346764me_tricizes
metrifies1439804me_trifi_es
metritises1247284me_tritises
moperies12313874moper__i_es
nemertines1245964nemer_tines
nephritides1753364nephritides
nephritises1653954nephritises
pelerines11311844peler__ines
perfidies1546604__perfidi_es
perilunes1147164__perilunes
pieridine1246144_pieridine_
piperazines2453494piperazines
piperines131610694piper__ines
primines123013704__p_rimines
pteridine1246744_pteridine_
pyridine1447744__pyridine_
repertoires1352654repertoires
repurifies1546144repurifi_es
reserpines1245844reser_pines
reverifies1645974reverifi_es
severities1348514severiti_es
spermines13310544_sper_mines
temerities1268484temeriti_es
teredines1049454__teredines
uridines989514___uridines
veratridines1652464veratridines

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit148819518.37617767.3
3Display Results51510.0163187.5
 (SQL Overall)178691518.81220278.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.