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

85 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
licenced1314577(None) 
licence11119351licence_
licencee12116461licencee
licencer12146131licencer
licences12129321licences
licensed11145721licensed
licencees13134642licencees
licencers13134642licencers
license9148422license_
licensee10166302licensee
licenser10155882licenser
licenses10118922licenses
licente91210892licente_
lichened1435752lichen_ed
likened12267352liken_ed
livened11238932liven_ed
lucence11147992lucence_
lucences12137312lucences
silenced1136272silenced
accented13107773accented
aliened81011743ali_en_ed
alimented1245313alimented
ascended1246513ascended
cadenced1435523cadenced
censed94016323__censed
defenced1537203defenced
dizened18267333dizen_ed
evidenced1643813evidenced
fenced124412713__fenced
financed1435113financed
incensed11277953incensed
incented112412543incented
ladened979053laden_ed
lamented1138193lamented
lanced93717723l__anced
latened8711923laten_ed
lensed74015473l__ensed
libeled10249413libe_led
libelled11317213libelled
licencing1443853licencing
licensees1184473licensees
licensers11114583licensers
licensor10113723licensor
lichted13268803lic_hted
licked134621563lic__ked
limned94811473li_mn_ed
lineated9711063lineated
linebred1144963linebred
lined64934643li__n_ed
linked114518213li__nked
linted74021823li__nted
lippened13255223lippen_ed
lisente71210703lisente_
listened9168813listen_ed
livener10278943liven_er
livered113111633live_red
liveried1238733liveried
lucencies1345843lucencies
lucency14104903lucenc_y
minced114114913mi__nced
pieced113912103pi_e_ced
pierced12347593pi_erced
refenced1438993refenced
relicensed1343683relicensed
richened1435953richen_ed
ripened1038203ripen_ed
scended11329873_scended
scented102811883_scented
science1138783science_
sciences1238773sciences
sconced12359173_sconced
sicced11489653sic__ced
sickened1546783sicken_ed
silence9310213silence_
silencer1036293silencer
silences10310073silences
slickened1644293slicken_ed
ticced11438443tic__ced
tierced10347053ti_erced
unfenced1437733unfenced
unlicensed1343023unlicensed
widened12328053widen_ed
winced124415343wi__nced
wizened20275423wizen_ed
zinced18419413zi__nced

Search took 10 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.1701051123.5
2DLD Change Limit146162859.06316127.3
3Display Results85850.0461847.8
 (SQL Overall)178691859.27919257.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.