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

86 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
personates12251069(None) 
personages13276531personages
personate112111421personate_
personated13258291personated
impersonates1653892impersonates
parsonages13255662parsonages
pepsinates1446372pepsinates
perborates1459212perborates
percolates14410422percolates
perennates1256762perennates
perforates1558862perforates
periodates1347862periodates
perorates11417022per_orates
personae102410552persona_e_
personage12226712personage_
personals11238572persona_ls
personalties1485152personalties
personas102511882persona__s
personator1245852personator
personators1345542personators
pronates10418372p_r_onates
resonates9412402re_sonates
arsenates979373_arsenates
carbonates1449133carbonates
coronates1110816923cor_onates
derogates11310973der_ogates
desolates10311793de_solates
detonates10310433de_tonates
essonites945153_essonites
germinates1347763germinates
hessonites1343693hessonites
impersonate1554363impersonate_
impersonated1763273impersonated
neonates8310063ne__onates
parsonage12225583parsonage_
penates93321603pe___nates
peonages1138473pe__onages
pepsinate1346633pepsinate_
pepsinated1545233pepsinated
perborate13510143perborate_
percolate13411163percolate_
percolated1548253percolated
perennate1147783perennate_
perennated1345693perennated
perforate1459463perforate_
perforated1656893perforated
perfusates1543993perfusates
periodate1248343periodate_
permeates13311773per_meates
perorate10417923per_orate_
perorated12412463per_orated
persecutes1444353persecutes
persona92812453persona___
personable1467073personable
personal102311573persona__l
personalise1367103personalise
personalises1476523personalises
personalism15137393personalism
personalist1399423personalist
personalities1556473personalities
personalizes2356703personalizes
personally1546943personally
personalty1555283personalty
personating1447673personating
personation1349483personation
personations1448393personations
personative1647073personative
personifies1695153personifies
personnel1143733person_nel
personnels1243203personnels
persons93717013person___s
persuades1245623pers_uades
phonates13410643p__honates
prelocates1468353prelocates
priorates11410763p_riorates
probates12414283p_r_obates
pronate9418873p_r_onate_
pronated11414053p_r_onated
prorates10418073p_r_orates
prostates11314423p_rostates
protonates12411693protonates
pulmonates1444153pulmonates
resinates9314763re_sinates
resonate8513513re_sonate_
resonated10510613re_sonated
terminates12410003terminates

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 Filter1786911406030.406440125.6
2DLD Change Limit140603866.59321326.1
3Display Results86860.0461869.6
 (SQL Overall)178691867.04525364.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.