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

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
absences124767(None) 
absence1137711absence_
absented1156622absented
absentee1067662absentee
absentees1164532absentees
absenter1086772absenter
absenters1156182absenters
absents93510722absen_ts
ambiences1545252ambiences
essences1047562essences
abbesses1235333abbesses
abduces1286243ab_duces
abeles84719393ab_e_les
abeyances1644613abeyances
abhenries1444503abhenries
abhenrys1641543abhenrys
abidances1445593abidances
abreacts1245643abreacts
abscess1133903abs__cess
abscesses1344103abscesses
abscises1246233abscises
abseiled1144733abseiled
abseils935973abse_ils
absent84016993absen__t
absently1345813absently
absinthes1442673absinthes
absinths1342953absinths
absolves1344413absolves
absterges1244763absterges
abstinences1552903abstinences
achenes12313493achen_es
advances1445613advances
agencies1138743a_gencies
agenes74720253a_gen_es
akenes104817343a_ken_es
alienees8118653alienees
alkenes114212753alken_es
ambiances1545713ambiances
ambience1455353ambience_
ambsaces1455213ambs_aces
amerces1149853a_merces
amesaces1246693amesaces
ardencies1247853ardencies
arenes64928393a_ren_es
arsenals847753arsenals
arsenates979373arsenates
arsenics1056763arsenics
arsenides1095613arsenides
arsenites9149173arsenites
arsenous847533arsenous
arsines73518833arsin_es
asepses946363a_sepses
assented957523assented
assenter867713assenter
assenters967003assenters
assents74512223assen_ts
assesses737383assesses
audiences1246003audiences
auspices1236443auspices
avenges1157543a_venges
avenses1049643a_venses
avenues1057183a_venues
balances1279973balances
baseness10910943baseness
basenjis1741943basenjis
benches143918603_b_enches
benes75536233_b_en_es
bennes86019013_b_ennes
blenches153310763_blenches
blendes104713683_blendes
bounces113813683_bounces
cadences1338473cadences
cassenes103611293cassen_es
defences1439633defences
essence947673essence_
faiences1337053faiences
fences114617113__fences
licences12129333licences
lucences12137313lucences
nascences1346233nascences
observes1346173observes
obsesses1036223obsesses
offences1645023offences
patiences1367443patiences
potences12710693potences
presences132113793presences
refences13311853refences
saliences11108063saliences
sapiences13116423sapiences
sciences1238783sciences
seances93015343__seances
senses63923943__senses
silences10310083silences
spences113413923_spences
subsenses1147473subsenses
tangences1246443tangences
unfences1337933unfences
usances967373_usances
valences1388513valences

Search took 9 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.656272394.8
2DLD Change Limit146162998.20317818.1
3Display Results99990.0462152.2
 (SQL Overall)178691998.90520066.4
 
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.