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

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

99 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
experiences2210605(None) 
expediences2354271expediences
experience2156441experience_
experienced2353811experienced
expedience2254342expedience_
expediencies2452922expediencies
inexperiences24113932inexperiences
reexperiences2472292reexperiences
emergences15105953e_mergences
esperances1446253esper_ances
esuriences12105303e_suriences
excellences2252553excellences
expectances2493343expectances
expediency2553113expedienc_y
expedients2044143expedien_ts
experiencing2452653experiencing
experimented2473243experimented
experimenter2373173experimenter
experimenters2472443experimenters
experiments2255913experimen_ts
inexpediences25123093inexpediences
inexperience23124263inexperience_
inexperienced25112783inexperienced
reexperience2372423reexperience_
reexperienced2571793reexperienced
adherences1664884adher_ences
advertences1754054advertences
aperients1178254_aperien_ts
appetences1644594appe_tences
coherences1787044coher_ences
coprinces1547484cop_ri_nces
deferences1677874defer_ences
dependences1745884dependences
deterrences1455184deterrences
divergences1874494divergences
ebulliences1552384ebulliences
effervesces2261734effervesces
emergence14136614e_mergence_
emergencies16124514e_mergencies
emperies12314564emperi___es
epergnes1156714e_per_gn_es
eserines8413744e_seri_n_es
esperance1346694esper_ance_
esurience11126004e_surience_
esuriencies1353824e_suriencies
excellence2152714excellence_
excellencies2351994excellencies
excrescences2253444excrescences
exigences1946324ex__igences
existences1944824ex_istences
exocrines1845484exocri_n_es
expectance2363624expectance_
expectancies2562244expectancies
expedient1945784expedien__t
expediently2453794expediently
expedites1946164expedi__tes
expellees18133804expelle__es
expellents1943744expellen_ts
expenses17138374exp___enses
experiential2163794experiential
experiment2147514experimen__t
experimental2364124experimental
expertises1947104exper_tises
expertizes28106014exper_tizes
expertness1944824exper_tness
expertnesses2144844expertnesses
expiries1747754expiri___es
expresses1837864exp_r_esses
extermines1947784extermin_es
externes1539834exter__n_es
exuberances2252464exuber_ances
eyepieces1642644e_yepie_ces
impatiences1753704impatiences
impenitences1854024impenitences
impertinences1953594impertinences
inexpedience24123444inexpedience_
inexpediencies2662164inexpediencies
inferences15410354infer_ences
inherences1568974inher_ences
leniences1148144__leniences
mergences14137554__mergences
obediences1544324_obediences
patiences1367434__patiences
penitences1447974__penitences
permeances1645654__permeances
pertinences1545744__pertinences
piperines131610694piperi_n_es
presences132113794__presences
pretences132312614__pretences
princes113015144__p_ri_nces
pruriences1444704_pruriences
reemergences1753044reemergences
references1589354refer_ences
reverences1579174rever_ences
sapiences13116424sap__iences
supergenes13610934supergen_es
supervenes15610074superven_es
temperances1754734temper_ances
vergences15128064__vergences

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 Filter1786911488190.436409841.7
2DLD Change Limit148819998.70617093.8
3Display Results99990.0601650.0
 (SQL Overall)178691999.20219418.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.