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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
licences1212932(None) 
licence11119361licence_
licenced13145771licenced
licencee12116461licencee
licencees13134641licencees
licencer12146131licencer
licencers13134641licencers
licenses10118921licenses
lucences12137311lucences
license9148422license_
licensed11145722licensed
licensee10166302licensee
licensees1184472licensees
licenser10155882licenser
licensers11114582licensers
licente91210892licente_
lucence11148002lucence_
lucencies1345842lucencies
sciences1238772sciences
silences10310072silences
absences1247673absences
alienees8118653ali_enees
bicepses1443873bicepses
cadences1338473cadences
censes83721803__censes
cicelies1269753cicelies
clarences1346453clarences
decencies1448943decencies
defences1439633defences
dickenses1645073dickenses
dienes75719903di_en_es
diligences1444333diligences
eminences1347403eminences
epicenes1249253epicen_es
essences1047563essences
evidences1556333evidences
exigences1946323exigences
faiences1337043faiences
fences114617113__fences
fiances12310673fi_ances
finances1338653finances
florences1446893florences
icones84616383_icon_es
incenses102411003incenses
lacunes9159623lacun_es
laitances1145613laitances
lances84824103l__ances
larcenies1147533larcenies
latencies1147773latencies
launces9329003l_aunces
lenes54738523l__en_es
leniences1148143leniences
lenses64620893l__enses
lianes63819323li_an_es
libelees10227213libelees
licencing1443853licencing
licensor10113723licensor
licensors11104023licensors
licensures1243053licensures
lichees123512783lic_hees
lichened1435753lichen_ed
lichenins1444843lichenins
lichenose1443363lichenose
lichenous1444313lichenous
lichens123510683lichen__s
liches114724293lic__hes
licorices1346353licorices
lieges74113443li_e_ges
liens56525503li_en__s
liernes739623li_ernes
likened12267353liken_ed
likeness12229863likeness
likens105613703liken__s
limeades11116643limeades
limens84618033limen__s
lineages979183lineages
linens64818393linen__s
lines57054573li__n_es
lisente71210703lisente_
litanies8310993litanies
liteness82213213liteness
livened11238933liven_ed
livener10278943liven_er
liveners11217933liveners
liveness112411393liveness
livens94314893liven__s
liveries11314373liveries
lozenges1843053lozenges
lucency14104903lucenc_y
lucernes1046363lucernes
lycees11428863lyce__es
micelles1288833micelles
minces104420803mi__nces
nascences1346233nascences
niceness1039843niceness
niceties10310863niceties
nieces84112713ni_e_ces
offences1645023offences
pieces104217273pi_e_ces
pierces113411193pi_erces
pinenes93416673pinen_es
potences12710693potences
recencies13312253recencies
refences13311843refences
relicenses1245413relicenses
reticences1447453reticences
saliences11108063sali_ences
scenes84520353_scen_es
science1138783science_
sconces113811453_sconces
silence9310213silence_
silenced1136273silenced
silencer1036293silencer
silencers1145283silencers
sixpences2043633sixpences
spences113413923_spences
tierces93710453ti_erces
unfences1337933unfences
valences1388513valences
violences1445493violences
wienies102213683wi_enies
winces114819113wi__nces

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 Limit1461621226.62622058.9
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.07825246.0
 
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.