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

70 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
pervaders154443(None) 
pervader1444861pervader_
pervades1437351pervade_s
evaders1136932_e_vaders
paraders113113112par_aders
persuaders1343352persuaders
pervade1337022pervade__
pervaded1535372pervade_d
abraders1137343abr_aders
beaders104120183be__aders
beheaders1545153beheaders
bereavers1446123bereavers
degraders12245933degraders
deriders102411853der_iders
erasers74413943_er_asers
evader1036813_e_vader_
evades1039023_e_vade_s
germanders1444603germanders
graders94716013_gr_aders
headers113819393he__aders
herders113914123her__ders
invaders12105303_invaders
leaders83819603le__aders
parader103914863par_ader_
parades104121463par_ade_s
paradors113411903par_adors
parkades1538273parkade_s
partakers1536563partakers
pedalers11239393pe_dalers
percales12313803percale_s
perchers153611523per_chers
perfumers1683713perfumers
periderm1346803per_iderm
periderms1444993per_iderms
peripters1368123peripters
perjurers18224463perjurers
persuader1244263persuader_
persuades1245623persuade_s
perusers10328803per_users
pervading1636303pervading
perverse1336103perv__erse
pervert12315583perv__ert
perverters1544963perverters
perverts1337533perv__erts
pesades10310903pe_sade_s
petnapers1343823petnapers
phreakers1834673phreakers
pleaders113210183p_leaders
praters94921653p_r_aters
prayers124212853p_r_ayers
preavers13910263p_reavers
prefacers1636293prefacers
prefades1439533prefade_s
preluders1234423preluders
preorders1235403preorders
preparers13197673preparers
presagers1236943presagers
presiders1248213presiders
prevailers15123833prevailers
prodders1237463p_rodders
providers1535593providers
readers83823773__readers
reloaders1036423reloaders
serenaders11204663serenaders
servers103214833serv__ers
servicers1444663servicers
spreaders1236503spreaders
threaders1365743threaders
traders84316953_tr_aders
treaders93311843_treaders

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.406440125.6
2DLD Change Limit148641707.17320722.3
3Display Results70700.0302333.3
 (SQL Overall)178691707.60923484.2
 
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.