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

115 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
perspex183418(None) 
perplex1836152perplex
perse75429522pers_e_
perses85428062pers_es
perspexes2043842perspexes
aruspex1642543aruspex
auspex1574793_auspex
berseem1166463berseem
desex13311983de_s_ex
erses55826803_ers_es
haruspex2041683haruspex
herpes115517323her_pes
jersey1636333jers_ey
kersey1336793kers_ey
oersted839563oersted
parapet11317643parapet
parse75236993pars_e_
parsec105914483pars_ec
parsed96323893pars_ed
parser84822373pars_er
parses85534703pars_es
parsley1247803parsley
pease75231113peas_e_
peasen84815963peas_en
peases85229473peas_es
peeped113915393pe_eped
peeper103614803pe_eper
peise75825773peis_e_
peised94817683peis_ed
peises84125043peis_es
pensee8417313pens_ee
pensees9311203pensees
penster92811953penster
pepped103113403pe_pped
pepper93512943pe_pper
percept133112523percept
perched154713243perched
percher143313423percher
perches143717953perches
perdie94718513perdie_
perdue93912633perdue_
perdues103511333perdues
pere66450263per__e_
perea75026443per__ea
peres76246643per__es
perigee101113393perigee
periled10316323periled
perinea9313043perinea
peripety1546193peripety
peripter1278753peripter
perished14310093perished
perishes13313753perishes
perked134617693per_ked
perkier133813123perkier
permed115217353per_med
perp89029893per_p__
perpend12259353per_pend
perpent112318813per_pent
perps95521483per_p_s
perries93226603perries
persalt9315413persalt
persist9315853persist
person83517873pers_on
persona92812453persona
persons93717013persons
perspire1246663perspire
perspired1444223perspired
perspires1346663perspires
perspiry1543783perspiry
perter84422283per_ter
peruke123210393peruke_
peruked14367893peruked
perukes133210113perukes
peruse84016843peruse_
perused103112203perused
peruser93511373peruser
peruses94018163peruses
pester84827593pe_ster
prepped11329903prepped
prese75228383pres_e_
preset84430983pres_et
pressed103317313pressed
presser93717623presser
presses93523153presses
prester93519623prester
prex135722973p_r__ex
propel103714063p_ropel
proper104319953p_roper
prosper114012193prosper
purse76028893purs_e_
pursed95220883purs_ed
purser85020473purs_er
purses84826373purs_es
pursier94012753pursier
pursue84512253pursue_
pursued10388133pursued
pursuer9338893pursuer
pursues94111373pursues
pyrex175211213pyr__ex
pyrope132810533pyrope_
pyropes142210193pyropes
serape84818413serape_
serapes95218103serapes
supersex1738423supers_ex
terse55026823ters_e_
terser67317823ters_er
verse84723583vers_e_
versed104515523vers_ed
verser94516963vers_er
verses94223763vers_es
verset94327323vers_et
verste94515633verste_
verstes104014283verstes
vertex1637373ver_tex
vesper1138083ve_sper

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.393454684.5
2DLD Change Limit1340271157.18618651.1
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.62523434.9
 
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.