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

62 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
perspire124666(None) 
perspired1444211perspired
perspires1346661perspires
perspiry1543781perspiry
respire9411542re_spire
acrospire1343973acrospire
aspire8612123__aspire
conspire1257873conspire
desire7415303de_s_ire
despise1038683de_spise
despite10410123de_spite
empire1039323_e_mpire
expire1538023_e_xpire
inspire938253_inspire
newswire1442603newswire
overspice1647123overspice
pensile92713543pens_ile
pensive122610393pens_ive
peppier10268323pe_ppier
pepsine11310603peps_ine
perceive1546973perceive
perdie94718513per_di_e
perdure10379623per_dure
peripter1278753peripter
perjure16327963per_jure
perkier133813123per_kier
perlite9317323per_lite
peroxide1848183peroxide
perse75429523pers___e
persevere1443993persevere
persist9315853pers_ist
personae102410553personae
perspex1834183persp_ex
perspexes2043843perspexes
perspiring1544853perspiring
persuade1145853persuade
peskier13319113pe_skier
pestier94317403pe_stier
pismire1135353p_ismire
porkpie1544673porkpi_e
prefire124012813p_refire
prepare111913623p_repare
preppie1058093preppi_e
preppier1156643preppier
prescore124812373prescore
preside10715613pres_ide
preslice1258623preslice
pressure1039773pressure
prestige11310733prestige
prestore104217353prestore
prewire124311143p_rewire
propine113020213p_ropine
purpure1195993pur_pure
pursier94012753purs_ier
reinspire1144223reinspire
respired1148993re_spired
respires10311903re_spires
respite9513033re_spite
spire75828693___spire
suspire937803_suspire
versine102515173vers_ine
vespine1237903ve_spine

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 Filter1786911461620.406440125.6
2DLD Change Limit146162626.82621412.5
3Display Results62620.0163875.0
 (SQL Overall)178691627.24824653.8
 
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.