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

76 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
pergolas115823(None) 
pergola1067621pergola_
perillas10310832perillas
personas102511882personas
plugolas1143132plugolas
pyrolas1239862pyr_olas
verglas1137812verg_las
acerolas1048053acer_olas
areolas71013863_areolas
argalas84011093_argalas
argols74514613_argol_s
arugolas944403arugolas
aureolas846853aureolas
cervelas1344673cervelas
dongolas1045343dongolas
ergots74512373_ergo_ts
ferulas103110753fer_ulas
hemiolas1387063hemiolas
hyperbolas2054983hyperbolas
hypergols1845013hypergol_s
jerboas1636163jerbo_as
nerolis71012783ner_olis
nerols6914893ner_ol_s
pagodas11367553p_agodas
parabolas1347013parabolas
pargos95719043pargo__s
paroles95025893par_oles
parols84722613par_ol_s
payolas12148973p_ayolas
pelotas9410723pe_lotas
pengos94612413pengo__s
percales12313803percales
percoids1339663percoids
percolate13411163percolate
percolates14410423percolates
pereons92815003pereo_ns
performs1547483performs
perigons11310083perigo_ns
perilla9311233perilla_
perilous10310693perilous
perils84121853per_il_s
periods10312243perio_ds
periplasm1594983periplasm
periplast1387283periplast
pernods1038483perno_ds
peroral9314793per_oral
perrons93115483perro_ns
persalts1038193persalts
persona92812453persona_
personae102410553personae
personal102311573personal
personals11238573personals
persons93717013perso_ns
perusals1047143perusals
petiolar1046173petiolar
petioles10311643petioles
petrols92913083petrol_s
plugola1043013plugola_
premolar1246633premolar
premolars1345023premolars
premolds1345843premolds
proas75028803p_r_o_as
prolan8414693p_r_olan
prolans9314273p_r_olans
proles84627203p_r_oles
pyrola1139003pyr_ola_
pyrroles1345453pyrroles
pyrrols1235403pyrrol_s
rerolls739943rer_olls
rugolas836373_rugolas
serosas7312663ser_osas
variolas1168543variolas
weigelas1243103weigelas
wergelds1342293wergelds
wergelts1253413wergelts
wergilds1342653wergilds

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 Filter1786911461620.420425454.8
2DLD Change Limit146162768.15617920.8
3Display Results76760.0332303.0
 (SQL Overall)178691768.60920756.3
 
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.