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

70 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
licencers1313464(None) 
licencees13134641licencees
licencer12146131licencer_
licences12129321licence_s
licensers11114581licensers
licence11119362licence__
licenced13145772licence_d
licencee12116462licence_e
licensees1184472licensees
licenser10155882licenser_
licenses10118922license_s
licensors11104022licensors
liveners11217932liven_ers
lucences12137312lucence_s
silencers1145282silencers
alieners889823ali_en_ers
ascenders1235683ascenders
cancers114018583__cancers
censers94313903__censers
centers94420603__centers
decenters122410373decenters
epicenters14114463epicenters
fencers123810623__fencers
incenters112510303incenters
lamenters1137683lamenters
lancers93616643l__ancers
larceners1135993larcen_ers
lavenders1334753lavenders
lenders84419643l__enders
libelers10238623libe_lers
libellers11236033libellers
licencing1443853licencing
license9148423license__
licensed11145723license_d
licensee10166303license_e
licensor10113723licensor_
licensure1143043licensure
licensures1243053licensures
licente91210893licente__
lickers134118253lic__kers
lientery1134883li_entery
likeness12229863liken_ess
limners93311563li_mn_ers
liners65428853li__n_ers
lingers84223303li__ngers
linkers114317713li__nkers
linters73822633li__nters
listeners9147323listen_ers
liteness82213213liten_ess
livener10278943liven_er_
liveness112411393liven_ess
lucence11148003lucence__
lucencies1345843lucencies
mincers113714853mi__ncers
misenters1139533misenters
niceness1039843nicen_ess
piecers114112253pi_e_cers
piercers12316723pi_ercers
pincers113916503pi__ncers
ricercars1353553ricercars
ripeners1036833ripen_ers
sciences1238773science_s
sickeners1535733sicken_ers
silencer1036293silencer_
silences10310073silence_s
slickeners1643663slicken_ers
spencers12269193_spencers
wideners12257993widen_ers
wieners103212483wi_en_ers
wincers123415363wi__ncers

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 Filter1786911486410.410435831.7
2DLD Change Limit148641707.15320780.2
3Display Results70700.0332121.2
 (SQL Overall)178691707.59623524.4
 
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.