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 “pearlescences” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
pearlescences196285(None) 
pearlescence1863191pearlescence_
coalescences1554213coa_lescences
opalescences1853093opa_lescences
pearlescent1553503pearlescen__t
preadolescences2291843preadolescences
putrescences18113883putr_escences
adolescences1753614_adolescences
candescences1654494_candescences
coalescence1455094coa_lescence_
defervescences2561564defervescences
detumescences20122444detumescences
evanescences1953234_evanescences
excrescences2253444_excrescences
florescences1993884flor_escences
incalescences16113504incalescences
obsolescences1962314obsolescences
opalescence1753754opa_lescence_
persistences1653864pe_rsistences
preadolescence2192014preadolescence_
prepubescences24111864prepubescences
presciences17127274p__r_esciences
presences132113794p__r_es_ences
pubescences1954284p__ubescences
putrescence17114274putr_escence_
recrudescences1861804recrudescences
senescences15135564se__nescences
turgescences1752844_turgescences
virescences18134544_vir_escences
acquiescences2562155acquiescences
adolescence1653855_adolescence_
arborescences1962465arborescences
candescence1554805_candescence_
concrescences15104345concrescences
convalescences20122265convalescences
decrescendos1861015decr_escendos
defervescence2461715defervescence_
dehiscences1953935de__hiscences
deliquescences2871445deliquescences
detumescence19102765detumescence_
effervescences27211825effervescences
efflorescences24101785_efflorescences
evanescence1853635_evanescence_
excrescence2153735_excrescence_
excrescencies2362005_excrescencies
fearlessness1545765fearles_sness
fearlessnesses1666745fearlessnesses
florescence1884415flor_escence_
fluorescences2083235fluorescences
incalescence15113985incalescence_
incandescences1862835incandescences
intumescences1983665intumescences
iridescences1793355_iridescences
juvenescences2762085juvenescences
luminescences1962475luminescences
maleficences2172245_ma_leficences
nascences1346235_na___scences
neurosciences1762645neur_osciences
obsolescence1862615obsolescence_
paleocene1345005p_a_leocen_e_
parlances1348955p_arl___ances
pearlashes1543265pearlas___hes
percipiences2053145pe_rcipiences
permanences1754495pe_r_manences
permeances1645655pe_rme__ances
persistence1554155pe_rsistence_
persistencies1752565pe_rsistencies
pertinences1545745pe_r_tinences
preadolescents1971635preadolescen_ts
prepubescence23112145prepubescence_
prescience16157295p__r_escience_
presence122213515p__r_es_ence_
pretences132312615p__r_e_tences
pubescence1854765p__ubescence_
putrescines1552585putr_escin_es
quiescences2454215__quiescences
recrudescence1762125recrudescence_
reminiscences1962555reminiscences
renascences1554865re__nascences
resplendences18122385resplendences
reviviscences23161955reviviscences
senescence14136075se__nescence_
tumescences1754155__tumescences
turgescence1653075_turgescence_
virescence17134865_vir_escence_

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit124790859.22013534.7
3Display Results85850.0631349.2
 (SQL Overall)178691859.68918442.7
 
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.