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

60 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
perpetrator155364(None) 
perpetrators1653391perpetrators
perpetuator1552721perpetuator
perpetrate1476652perpetrat_e
perpetrated1675072perpetrated
perpetrates1566202perpetrates
perpetration1647132perpetration
perpetuators1652662perpetuators
perforator1545443per_forator
permeator1347403perme__ator
perorator1149743per__orator
perpetrating1745203perpetrating
perpetrations1746373perpetrations
perpetuate1454793perpetuat_e
perpetuated1653753perpetuated
perpetuates1584303perpetuates
perpetuation1655343perpetuation
preparator1445243prep_arator
arbitrator1254394_arbitrator
celebrator1444984ce_lebrator
cooperator1446834coope_rator
corporator1446944corp_orator
deaerator10128114de_ae_rator
depreciator1654274depreciator
depredator1443974depre_dator
depurator1247024de_p_urator
desecrator1346004de_secrator
execrator1846564_e_xecrator
federator1346264fe_de_rator
generator1067594ge_ne_rator
imperator1347784_impe_rator
operator10310094__ope_rator
penetrate1149234pe_netrat_e
penetrated1347304pe_netrated
penetrates1248724pe_netrates
penetration1349894pe_netration
percolator1445914per_colator
perforators1644854per_forators
permeators1447404perme__ators
perorators1249354per__orators
perpetual1344484perpetua__l
perpetually1853864perpetually
perpetuals1453484perpetua_ls
perpetuating1753804perpetuating
perpetuations1754984perpetuations
perpetuity1753004perpetuit_y
persecutor1453244perse_cutor
personator1245854per_sonator
perspiratory1952964perspiratory
perverter1445564perve_r_ter
predator11310054p_r_e_dator
preparators1554724prep_arators
preparatory1853774prep_aratory
procurator1445514p_rocurator
propitiator1554224propitiator
protractor1446264p_r_otractor
respirator1265734resp_irator
retractor11218514__r_etractor
separator1146264se_p_arator
venerator1247264ve_ne_rator

Search took 10 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 Limit148819609.37615872.3
3Display Results60600.0302000.0
 (SQL Overall)178691609.82618185.5
 
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.