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

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

123 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
perea7502644(None) 
pere66450261pere_
pereia85217981pereia
peres76246641peres
area45843392_area
beret74946362beret
cere66741472cere_
cereal8315832cereal
cered85227442cered
ceres75540012ceres
ceria75125352ceria
dere56845902dere_
derma84918512derma
era35741502_er_a
ere36352772_ere_
fere76342232fere_
feres86038182feres
feria85922712feria
here76447102here_
hereat93527412hereat
heres86245902heres
herma105318882herma
mere67244442mere_
merer75126232merer
meres75143572meres
ocrea73311822ocrea
opera7313572oper_a
palea75028662palea
para65242172par_a
parae76335702parae
pare66760842pare_
pared86946762pared
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parka115120882parka
pea56657242p__ea
pedes85327292pedes
pee56066512pe_e_
peed76239182pe_ed
peek106031432pe_ek
peel65535612pe_el
peen65938082pe_en
peep85833692pe_ep
peer66238352pe_er
peered93819492peered
peers75130272peers
peery105719442peery
pees65257372pe_es
peke105926202peke_
pekes114623562pekes
pele65539552pele_
peles75738082peles
penes75839222penes
penna74520202penna
pepla9312862pepla
per56353092per__
perch124518832perch
perdu84216272perdu
perdy115417332perdy
pereon83517452pereon
peri65636972per_i
peril75425952peril
perinea9313032perinea
peris75537072peris
perk106232842per_k
perked134617692perked
perks115325802perks
perky145319482perky
perm85834632per_m
permed115217352permed
perms95524512perms
perp89029892per_p
perps95521482perps
perry105222712perry
perse75429522perse
perses85428062perses
pert66759322per_t
perter84422282perter
perv97224812per_v
pervs105117372pervs
peseta8310572peseta
pesewa1135542pesewa
peter74427592peter
petrel83111532petrel
pewee10319972pewee
phreak1536152phreak
pilea75123952pilea
plea66830602p_lea
pore66451262pore_
pored85234512pored
pores75849032pores
pree67044732p_ree
preed85128122preed
preen75925052preen
prees75937172prees
prep86427672p_rep
presa74319042presa
prex135722972p_rex
prey96228482p_rey
prez156126312p_rez
proa66229962p_roa
purda82914692purda
pure65543332pure_
puree74632842puree
purer75127902purer
pyre94925552pyre_
pyres105523882pyres
pyrex175211212pyrex
reread71715432reread
sera46141392ser_a
sere46153472sere_
sered65737292sered
serer55935512serer
seres55448892seres
spirea84015632spirea
terga63315642terga
terra54419662terra
urea46528062_urea
vera76828842ver_a
were76238332were_
yerba101010762yerba

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538001231.67332157.8
3Display Results1231230.0304100.0
 (SQL Overall)1786911231.99989390.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.