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

105 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
netizen163588(None) 
netizens1743861netizens
bedizen1935942bedizen
citizen1845712citizen
denizen1737662denizen
antigen8311123antigen
bedizens2044423bedizens
betaken13438283betaken
betide95115973betide_
betided114810203betided
betides104915263betides
betime105914833betime_
betimes115114413betimes
betise85616273betise_
betises94816123betises
betoken13386503betoken
between1234683between
citizens1943983citizens
denizens1835573denizens
dizen155214933__dizen
enliven1034903enliven
entice81316863entice_
enticed101411193enticed
enticer91510423enticer
entices91616333entices
entire61617703entire_
entires71517783entires
metier83517693meti_er
mizen164815273__mizen
monetize1949983monetize_
monetized2147153monetized
monetizes2049263monetizes
nation64322803nati_on
native9613013native_
natives10310823natives
neaten64214543ne_aten
neither1037573neither
nether94014163net_her
netlike11308913netlike_
netted74118713net_ted
netter63722023net_ter
nettier74211813nettier
nettle64514583nettle_
nettled8339943nettled
nettler7349503nettler
nettles73214083nettles
newie81813483newi_e_
newies91014073newi_es
newsmen1235893newsmen
notice8313443notice_
noticed1037863noticed
noticer937273noticer
notices9312283notices
notion64516583noti_on
onetime937623onetime_
pectize20259913pectize_
pectized22257593pectized
pectizes21229793pectizes
peptize20279483peptize_
peptized22237523peptized
peptizer21236473peptizer
peptizes21269853peptizes
petite84320653petite_
petites93820203petites
poetize18310773poetize_
poetized2037983poetized
poetizer1936813poetizer
poetizes19310253poetizes
regimen104411573regimen
regiven11478323regiven
rerisen73613643rerisen
resize154117723resize_
resized174614903resized
resizes164216843resizes
retaken113911803retaken
reticent10313293reticent
retie55735303reti_e_
retied75924983reti_ed
reties65436193reti_es
retile65929673retile_
retiled84420513retiled
retiles74426993retiles
retime85321803retime_
retimed104714653retimed
retimes95020173retimes
retine66237333retine_
retinene839803retinene
retines75134673retines
retire64927013retire_
retired84620143retired
retiree75019083retiree
retirer74715013retirer
retires74726213retires
rewiden1137533rewiden
seize143819503se_ize_
seized164313653se_ized
seizer154114573se_izer
seizes154317533se_izes
seizin153610853se_izin
unitize16310033unitize_
unitized1839233unitized
unitizer1746203unitizer
unitizes1739133unitizes
vetiver1336103vetiver
wizen175813863__wizen

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271057.14018771.3
3Display Results1051050.0502100.0
 (SQL Overall)1786911057.61023481.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.