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

57 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
perilunes114716(None) 
perilune1046981perilune_
demilunes1244472demilunes
periques1937652periqu_es
berlines102315453ber_lines
demilune1144423demilune_
kerplunks145883kerplunks
pedicures1445263pedicures
pemolines1348623pemolines
pepluses1287023pe_pluses
percalines1449743percalines
perdues103511333per_du_es
perdures11289683per_dures
perfumes1555893per_fumes
perfuses1358663per_fuses
periapses1346053periapses
pericopes1547873pericopes
perigees1189503peri_gees
perigons11310083perigon_s
perigynies1643963perigynies
periled10316323peril__ed
periling11316863perilin_g
perillas10310823peril_las
perilled11410113peril_led
perilous10310693peril_ous
perilousness1457793perilousness
perils84121853peril___s
perinea9313033peri__nea
perique1837523periqu_e_
perishes13313753peri_shes
peritonea1147303peritonea
peritus9311803peritu__s
perjures17268083per_jures
perlites10316363per_lites
permutes1238713per_mutes
perniones1148593perniones
perplexes2044683perplexes
perukes133210113per__ukes
peruses94018163per__uses
petiolules1252583petiolules
pilules9510623p__ilules
pralines102217723p_ralines
precludes1445053precludes
preludes1137833p_reludes
primines123013703p_rimines
primuses1237083p_rimuses
prolines102619693p_rolines
prunes83419063p_r__unes
pteridines1345463pteridines
purines94420763puri__nes
purlines103514053pur_lines
purslanes1145523purslanes
pyridines1546473pyridines
serines74229543seri__nes
terylenes1244933terylenes
tribunes1055853_tribunes
triunes74311383_tri_unes

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 Filter1786911486410.423422437.4
2DLD Change Limit148641577.01621186.0
3Display Results57570.0134384.6
 (SQL Overall)178691577.45223978.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.