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

71 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
personae10241055(None) 
persona92812451persona_
personage12226711personage
personal102311571personal
personas102511881personas
personate112111421personate
parsonage12225582parsonage
person83517872person__
personable1467072personable
personages13276532personages
personals11238572personals
personated13258292personated
personates122510692personates
personnel1143722personnel
persons93717012person_s
coronae94214893cor_onae
impersonal1454743impersonal
impersonate1554363impersonate
parson83817903parson__
parsonages13255663parsonages
parsonic1239703parsonic
parsons93516873parson_s
pennae84314033pe__nnae
pensione1039773pension_e
peonage1048723pe__onage
pepsinate1346633pepsinate
pepsine11310603pepsin_e
peptone11310763pepton_e
perborate13510143perborate
percolate13411153percolate
perennate1147783perennate
pereon83517453pereon__
pereons92815003pereon_s
perforate1459463perforate
perforce1544963perforce
pergola1067623pergola_
pergolas1158233pergolas
pericopae1565023pericopae
perinea9313033per_inea
periodate1248343periodate
peritonea1147303peritonea
peroneal1049163per_oneal
peroral9314793per_oral
perorate10417923per_orate
perron83216623perron__
perrons93115483perron_s
perse75429523pers___e
personalise1367103personalise
personalize2287333personalize
personally1546933personally
personalty1555283personalty
personative1647073personative
personator1245853personator
personify1744013personify
personnels1243193personnels
perspire1246663perspire
persuade1145853persuade
presence122213513presence
presoak1348453preso_ak
presolve1347073presolve
presong1039843preson_g
pronate9418873p_r_onate
prone75332623p_r_on_e
psoae74411623p__so_ae
purslane1045783purslane
pyrone112714473pyr_on_e
resonate8513513re_sonate
seasonal847263seasonal
serosae7310243ser_osae
versine102515173versin_e
versional1245863versional

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.1531167915.0
2DLD Change Limit146162718.00318263.4
3Display Results71710.0302366.7
 (SQL Overall)178691718.18621828.9
 
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.