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

82 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
licencer1214613(None) 
licence11119361licence_
licenced13145771licenced
licencee12116461licencee
licencers13134641licencers
licences12129321licences
licenser10155881licenser
licencees13134642licencees
license9148422license_
licensed11145722licensed
licensee10166302licensee
licensers11114582licensers
licenses10118922licenses
licensor10113722licensor
licente91210892licente_
livener10278942liven_er
lucence11148002lucence_
lucences12137312lucences
silencer1036292silencer
aliener71011193ali_en_er
ascender1136733ascender
cancer104220923__cancer
censer84516583__censer
center84421413__center
decenter112412163decenter
epicenter1395503epicenter
fencer114613533__fencer
fiercer12356953fi_ercer
incenter102212093incenter
lamenter1038863lamenter
lancer84319973l__ancer
larcener1036493larcen_er
lavender1235143lavender
lender73921273l__ender
libeler9219003libe_ler
libeller10297433libeller
licencing1443853licencing
licensees1184473licensees
licensors11104023licensors
licensure1143043licensure
lichened1435753lichen_ed
licker125222043lic__ker
lieder74912323li_e_der
liefer9529573li_e_fer
lientery1134883li_entery
liever94611863li_e_ver
likelier1235283likelier
likened12267353liken_ed
limner84112873li_mn_er
liner55938923li__n_er
linger75226003li__nger
linier64423793li__nier
linker104321473li__nker
linter64625343li__nter
lisente71210703lisente_
listener8158313listen_er
livelier1136873livelier
livened11238933liven_ed
liveners11217933liven_ers
lucencies1345843lucencies
lucency14104903lucenc_y
mincer104017363mi__ncer
misenter10310833misenter
piecer105213083pi_e_cer
piercer11337773pi_ercer
pincer104019173pi__ncer
recenter102715443recenter
ricercar1263333ricercar
ripener937903ripen_er
science1138783science_
sciences1238773sciences
sickener1436603sicken_er
silence9310213silence_
silenced1136273silenced
silencers1145283silencers
silences10310073silences
silenter838873silenter
slickener1544043slicken_er
spencer113610973_spencer
widener11318693widen_er
wiener94513543wi_en_er
wincer115018193wi__ncer

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.1731032896.0
2DLD Change Limit146162827.26620115.9
3Display Results82820.0302733.3
 (SQL Overall)178691827.46923924.4
 
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.