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

221 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
license914842(None) 
licence11119361licence
licensed11145721licensed
licensee10166301licensee
licenser10155881licenser
licenses10118921licenses
licente91210891licente
cense75121402__cense
incense92410302incense
lense54523432l__ense
licenced13145772licenced
licencee12116462licencee
licencer12146132licencer
licences12129322licences
licensees1184472licensees
licensers11114582licensers
licensor10113722licensor
licensure1143042licensure
lichenose1443362lichenose
lichens123510682lichens_
liens56525502li_ens_
likens105613702likens_
limens84618032limens_
linens64818392linens_
lisente71210702lisente
livens94314892livens_
lucence11148002lucence
relicense1145252relicense
alienee71013153ali_enee
aliens65619213ali_ens_
biceps12447713biceps_
bicepses1443873bicepses
bices95029963bice_s_
biocenose1343543biocenose
cease75227653__cease
censed94016323__censed
censer84516583__censer
censes83721803__censes
decease1049523decease
defense1137503defense
dense65923503__dense
dicers94720743dicers_
dices86434243dice_s_
dickens144410133dickens_
dickenses1645073dickenses
diene65720133di_en_e
dienes75719903di_enes
diocese1036853dioce_se
disease83213843disease
diseuse83110723diseuse
dispense11129783dispense
diverse11429993diverse
dizens164911393dizens_
eocene8311613eocen_e
epicene1148593epicen_e
epicenes1249253epicenes
expense16127873expense
fices106031163fice_s_
ficins113513983ficins_
finesse10187643finesse
flense938903_flense
givens10379733givens_
ices66129643_ice_s_
icones84616383_icones
icons76516493_icons_
immense1135293immense
incensed11277953incensed
incenses102411003incenses
intense72511903intense
lacers85225253lacers_
laces76141763lace_s_
lactase937963lactase
lactose969493lactose
lacunae9116803lacunae
lacune8169673lacun_e
lacunes9159623lacunes
lacunose1083793lacunose
ladens74516233ladens_
laicise939333laic_ise
latens64620213latens_
lease55230263l__ease
lebens8310093lebens_
lenes54738523l__enes
lens46146493l__ens_
lensed74015473l__ensed
lenses64620893l__enses
liaise6310693li_aise
liane54720663li_an_e
lianes63819323lianes_
libelee92510983libelee
libels85112693libels_
libers84721443libers_
lice66045063lic___e
licencees13134643licencees
licencers13134643licencers
licensable1443073licensable
licensing1244753licensing
licensors11104023licensors
licensures1243053licensures
lichee114017973lic_hee
lichees123512783lichees_
lichen114012743lichen__
lichened1435753lichened
lichenin1345053lichenin
liches114724293liches_
lichis115212593lichis_
lichts113712383lichts_
lickers134118253lickers_
licks115325393lic_ks_
liege65314433li_e_ge
lieges74113443li_eges
lien45339803li_en__
lienal63912783li_enal
lierne638023li_erne
liernes739623liernes
liers55130403li_ers_
lies46454193li_e_s_
lieus56218483li_eus_
lieve86315473li_e_ve
lifers95617843lifers_
ligans76817733ligans_
ligase7259913li_gase
ligers75022043ligers_
liken911818843liken__
likened12267353likened
likeness12229863likeness
likers104620913likers_
likes96231903like_s_
likest104914383like_st
likewise1543263likewise
limans84816303limans_
limeade1076123limeade
limen75426033limen__
limes75636503lime_s_
limeys11429273limeys_
limns75718393li_mns_
lindens839413lindens_
line46965573li__n_e
lineage878983lineage
lineate7815153lineate
linen55728723linen__
lineny94011443linen_y
liners65428853liners_
lines57054573line_s_
linins65922143linins_
linns56123333li_nns_
lins47059053li__ns_
linsey938993li__nsey
lioness739103lioness
lionise7310373lionise
lions55923213li_ons_
lipase8239103li_pase
lipins85016883lipins_
lippens11328533lippens_
listens74014133listens_
liteness82213213liteness
liters65429883liters_
liven85021733liven__
livened11238933livened
livener10278943livener
liveness112411393liveness
livers94927823livers_
lives86133193live_s_
livest95315733live_st
lodens74315063lodens_
lozenge1743243lozenge
lucences12137313lucences
lucency14104903lucency
lucent8313823lucen_t
lucerne945753lucerne
lucernes1046363lucernes
lucerns935753lucerns_
luces75528433luce_s_
lumens85013973lumens_
lycee104716743lyce__e
lycees11428863lycees_
mense75025633__mense
micelle1178343micelle
miens76118303mi_ens_
miocene1147923miocen_e
misease92713043misease
missense1037963missense
mizens174610253mizens_
niceness1039843niceness
nicest82315663nice_st
nicoise937923nicoise
offense1343683offense
picante11310523picante
pinene82915643pinen_e
pinenes93416673pinenes
pliocene1244593pliocen_e
pulicene1245723pulicen_e
relicensed1343683relicensed
relicenses1245413relicenses
ricers84120993ricers_
rices75536153rice_s_
richens12349733richens_
ricins83618703ricins_
rinse54820973ri__nse
ripens85012173ripens_
scene77220573_scen_e
scenes84520353_scenes
science1138783science
sense55526823__sense
sices75637273sice_s_
sickens134411483sickens_
silence9310213silence
sirens65318153sirens_
slicers94114923slicers_
slices84022853slice_s_
slickens14317263slickens_
spense83912433_spense
sublicense1443123sublicense
tense55225843__tense
unlicensed1343023unlicensed
vices105725533vice_s_
vitesse1044583vitesse
vixens16286203vixens_
widens106212723widens_
wienie9229973wi_enie
wizens186110263wizens_

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.390458182.1
2DLD Change Limit1340272216.03022226.7
3Display Results2212210.0932376.3
 (SQL Overall)1786912216.51327436.1
 
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.