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 “persona” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 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
persona9281245(None) 
person83517871person_
personae102410551personae
personal102311571personal
personas102511881personas
persons93717011persons
parson83817902parson_
parsons93516872parsons
pereon83517452pereon_
pereons92815002pereons
pergola1067622pergola
perron83216622perron_
perrons93115482perrons
personage12226712personage
personals11238572personals
personate112111422personate
presong1039842presong
arson55118833_arson_
arsons63917213_arsons
bedsonia1153753bedsonia
corona83817403cor_ona
germina1038493germina
hereon93914363hereon_
heron85025503her_on_
herons94820543her_ons
impersonal1454743impersonal
jerboa1535633jerbo_a
kelson1038153kelson_
kelsons1137323kelsons
krona93611793_kr_ona
lesson64412043lesson_
lessons73811013lessons
merlon83012353merlon_
merlons93311273merlons
meson74118313me_son_
mesons83215843me_sons
nelson638423nelson_
nelsons738003nelsons
operon8811773oper_on_
operons91411743oper_ons
paisana94010223paisana
pardon94618733pardon_
pardons103817623pardons
parsing103819553parsing
parsonage12225583parsonage
parsonic1239703parsonic
parton84720993parton_
partons94620513partons
peasant9314923peasant
peasen84815963peasen_
peising103416763peising
pelon74423213pe_lon_
pelota8612833pe_lota
pembina1345213pembina
penna74520203pe__nna
pennon8310643pennon_
pennons939713pennons
pension9412203pension_
pensione1039773pensione
pensions10311693pensions
peon65635243pe__on_
peons75327183pe__ons
peony105717563pe__ony
pepsin10310853pepsin_
pepsine11310603pepsine
pepsins11310433pepsins
peptone11310763peptone
percent113520603percent
percoid12312313percoid
perea75026443per__ea
pereia85217983per_eia
pereion9312053pereion_
pereions10310853pereions
perform1439273perform
pergolas1158233pergolas
peridia10312363peridia
perigon1039853perigon_
perigons11310083perigons
perilla9311223perilla
perinea9313033perinea
period9314983perio_d
periods10312243periods
peritonea1147303peritonea
perking143716463perking
permian112612283permian
perming123416093perming
pernod9310453perno_d
pernods1038483pernods
peroneal1049163per_oneal
peroral9314793per_oral
peroxy1838243per_oxy
perpend12259343perpend
perpent112318803perpent
persalt9315413persalt
perse75429523pers__e
perses85428063pers_es
persist9315853persist
personable1467073personable
personages13276533personages
personally1546933personally
personalty1555283personalty
personated13258293personated
personates122510693personates
personator1245853personator
personify1744013personify
personnel1143723personnel
perspex1834173perspex
perusing11811063perusing
peseta8310573pe_seta
pesewa1135543pe_sewa
peso66925823pe_so__
pesos77221623pe_so_s
pirana8713263pir_ana
poison8312223poison_
poisons9310353poisons
prajna1535073p_rajna
presa74319043pres__a
present94022733present
presoak1348453presoak
presold1059603presold
presort95219533presort
prion75119993p_rion_
prions84317783p_rions
prison8514023prison_
prisons9313223prisons
proa66229963p_r_o_a
prone75332623p_r_one
prong85218113p_r_ong
prosoma11310223prosoma
purana8712933pur_ana
pursing103715553pursing
pyrola1139003pyr_ola
pyrone112714473pyr_one
reason62616333reason_
reasons72514943reasons
retsina74710603retsina
season62714903season_
seasonal847263seasonal
seasons72614233seasons
sermon8413553sermon_
sermons9311783sermons
serosa6313023ser_osa
telson6310293telson_
telsons739213telsons
trona54118953_tr_ona
unperson1046383unperson_
unpersons1146853unpersons
verbena1235373verbena
versant10313833versant
versine102515173versine
versing112314193versing
version10310923version_
versional1245863versional
versions11310353versions
verso85314633verso__
versos93812803verso_s
weason93210823weason_
weasons102310583weasons

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340271586.98319193.3
3Display Results1581580.0463434.8
 (SQL Overall)1786911587.17224915.1
 
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.