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

56 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
pteryla124330(None) 
pterylae1343011pterylae
pterygia1442412pterygia
acerola947833acerola
apteral9311523apteral_
apteria9312923apter_ia
apteryx1942383aptery_x
beryl101211673_beryl_
beryls11107883_beryls
eternal72910893eternal
ferula93011173_ferula
paella8410923pae_lla
patella938963pate_lla
paternal1038333paternal
peery105719443peery__
pepla9312863p_e_pla
perea75026443p_er_ea
pereia85217983p_ereia
pergola1067623p_ergola
peril75425953p_eril_
perilla9311233p_erilla
perils84121853p_erils
pertly115312553p_ertly
petrale9312623petrale
petrel83111533petrel_
petrels9279373petrels
petrol82714063petrol_
petrols92913083petrols
phenyl1435323phenyl_
phenyls1534333phenyls
phyla13469183p__hyla
propyla14296633propyla
pterin81014153pter_in
pterins9812993pterins
pterygial1542493pterygial
puerile9310093puerile
pyrola1139003p_yrola
stela54019043ste__la
stella63612973ste_lla
sterile7316603sterile
sterna63712763ster_na
sternal73411913sternal
sternly1037853sternly
sterol6613333sterol_
sterols7313443sterols
tela45532973_te__la
terbia8311163_terbia
terga63315643_ter_ga
tergal72912833_tergal
termly1138433_termly
terra54419673_ter_ra
tesla55612603_te_sla
tetryl935693_tetryl_
tetryls1034643_tetryls
torula6610393_torula
tryma1037223_t_ryma

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 Filter1786911340270.423422437.4
2DLD Change Limit134027567.01619103.1
3Display Results56560.0134307.7
 (SQL Overall)178691567.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.