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

74 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
latencies114777(None) 
patencies1349171patencies
agencies1138742_agencies
blatancies1444372blatancies
cadencies1447322cadencies
lambencies1643802lambencies
lucencies1345842lucencies
potencies1369302potencies
valencies1446412valencies
ardencies1247853ardencies
atonies75320953_aton_ies
cadences1338473cadenc_es
catenaries1248663catenaries
catenates11311813catenates
catenoids1246433catenoids
clarences1346453clarenc_es
clemencies1644733clemencies
coagencies1545623coagencies
cogencies1448103cogencies
decencies1448943decencies
dilatancies1453253dilatancies
eateries8324313eate_ries
faiences1337043faienc_es
fancies124018783fa__ncies
flatulencies1751773flatulencies
fluencies1445933fluencies
laitances1145613laitanc_es
lances84824103la__nc_es
lanciers10308543la__nciers
larcenies1147533larcen_ies
latches123320123lat__ches
latency1236033latenc__y
latened8711923laten__ed
lateness82614073laten_ess
latenesses10413363latenesses
latening9711493laten_ing
latens64620213laten___s
latents75214313laten__ts
laterites9715053laterites
laterizes18513013laterizes
latexes1438313late__xes
latices9313763lat_ic_es
latinities10410163latinities
latinizes18610153latinizes
lattices1038383lattic_es
launces9329003la_unc_es
launches1387903la_unches
leniencies1246193leniencies
licencees13134643licencees
licences12129323licenc_es
litanies8310993litan_ies
literacies1248803literacies
lucences12137313lucenc_es
nancies93516843na__ncies
nascencies1444553nascencies
patentees1196543patentees
patiences1367433patienc_es
plangencies1653793plangencies
potences12710693potenc_es
pudencies1445783pudencies
ratanies8312923ratan_ies
recencies13312253recencies
regencies1249283regencies
saliencies1246133saliencies
sapiencies1445113sapiencies
stenches132110293_stenches
stencils1046403_stencils
tangencies1345753tangencies
tenches123515523__tenches
tennies73017973__tennies
urgencies1256643urgencies
vacancies1645493vacancies
valences1388513valenc_es
valencias1443633valencias

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 Filter1786911486410.436409841.7
2DLD Change Limit148641746.73322076.5
3Display Results74740.0332242.4
 (SQL Overall)178691747.20224811.3
 
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.