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

130 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
licence1111936(None) 
licenced13145771licenced
licencee12116461licencee
licencer12146131licencer
licences12129321licences
license9148421license
licente91210891licente
lucence11148001lucence
licencees13134642licencees
licencers13134642licencers
licensed11145722licensed
licensee10166302licensee
licenser10155882licenser
licenses10118922licenses
lisente71210702lisente
lucences12137312lucences
lucency14104902lucency
science1138782science
silence9310212silence
absence1137713absence
alienee71013153ali_enee
cadence1239063cadence
cense75121403__cense
clarence1246453clarence
decency1537453decency
defence1339893defence
diene65720133di_en_e
diligence1344423diligence
eminence1247513eminence
eocene8311613eocen_e
epicene1148593epicen_e
essence947673essence
evidence1446553evidence
exigence1846553exigence
faience1237513faience
fence105319913__fence
fiance11310743fi_ance
fierce11348913fi_erce
finance1238573finance
florence1347063florence
hence104920043__hence
incense92410303incense
lacunae9116803lacunae
lacune8169673lacun_e
laitance1045973laitance
lance75126723l__ance
latency1236033latency
launce8469183l_aunce
lenience1048333lenience
lense54523433l__ense
liane54720663li_an_e
libelee92510983libelee
lice66045063li___ce
licencing1443853licencing
licensees1184473licensees
licensers11114583licensers
licensor10113723licensor
licensure1143043licensure
lichee114017973lic_hee
lichen114012743lichen__
lichened1435753lichened
lichenin1345053lichenin
lichenose1443363lichenose
lichens123510683lichen_s
licorice1246133licorice
liege65314433li_e_ge
lien45339803li_en__
lienal63912783li_enal
liens56525503li_en_s
lierne638023li_erne
lieve86315473li_e_ve
liken911818843liken__
likened12267353likened
likens105613703liken_s
limeade1076123limeade
limen75426033limen__
limens84618033limen_s
line46965573li__n_e
lineage878983lineage
lineate7815153lineate
linen55728723linen__
linens64818393linen_s
lineny94011443linen_y
liven85021733liven__
livened11238933livened
livener10278943livener
livens94314893liven_s
lozenge1743243lozenge
lucencies1345843lucencies
lucent8313823lucen_t
lucerne945753lucerne
lycee104716743lyce__e
micelle1178343micelle
mince95325233mi__nce
miocene1147923miocen_e
nascence1256183nascence
niece74814503ni_e_ce
offence1545353offence
pence94924453__pence
picante11310523picante
piece96717993pi_e_ce
pierce104010393pi_erce
pinene82915643pinen_e
pliocene1244593pliocen_e
potence11711363potence
pulicene1245723pulicen_e
recency1438633recency
refence12312233refence
relicense1145253relicense
reticence1347623reticence
salience10117903sali_ence
scene77220573_scen_e
sciences1238773sciences
sconce104711723_sconce
silenced1136273silenced
silencer1036293silencer
silences10310073silences
since75024173si__nce
sithence1344793sithence
sixpence1943543sixpence
spence103813793_spence
thence112010843_thence
tierce8339843ti_erce
unfence1239193unfence
valence1268773valence
violence1345713violence
whence14187923_whence
wienie9229973wi_enie
wince105220883wi__nce
yince105214253yi__nce

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271305.90622693.4
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.35828104.9
 
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.