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

180 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
denizen173766(None) 
denizens1835571denizens
bedizen1935942bedizen
denied84318632deni_ed
denier74420692deni_er
denies74729642deni_es
denimed1159232denimed
denizened2042752denizened
dizen155214932d__izen
netizen1635882netizen
adenine8311213adenine_
adenines9310193adenines
agenize172910153agenize_
agenized19257733agenized
agenizes18269743agenizes
agnize16329563agnize_
agnized18247223agnized
agnizes17328843agnizes
bedizens2044423bedizens
benign938313beni_gn
benison937123benison
benzene1836343ben_zene
benzin1738933ben_zin
benzine1839343benzine
citizen1845713citizen
daimen92210573d_aimen
deaden83714323de_aden
deadmen11248573deadmen
deafen10389673de_afen
deaired9411533deaired
debited113311623debited
decibel1235993decibel
decide104116873decide_
decided124312423decided
decider114213183decider
decides114217653decides
decile94619213decile_
deciles104417723deciles
deepen9339193de_epen
defied115016383defi_ed
defier105118653defi_er
defies104624053defi_es
defile105216663defile_
defiled124013103defiled
defiler113911883defiler
defiles114016843defiles
define104718143define_
defined123813823defined
definer114413773definer
defines114118683defines
defuze19487843defuze_
defuzed21447043defuzed
defuzes20398303defuzes
deice84320033de_ice_
deiced104214483de_iced
deicer94114413de_icer
deices94119373de_ices
deign74312803de_i_gn
deionize1858683deionize_
deionized2057153deionized
deionizer1945803deionizer
deionizes1958213deionizes
delime9314043delime_
delimed11310723delimed
delimes10314193delimes
deliver113312243deliver
demies94825803demi_es
demirep1236213demirep
demise94618323demise_
demised113613683demised
demises103719563demises
demonize20311533demonize_
demonized2239853demonized
demonizes21311063demonizes
dendron947653dendron
dene56643413den__e_
denes65639723den__es
dengue838253dengue_
dengues938183dengues
deni56929393deni___
denial74720513deni_al
denials84114133denials
deniers84515183deniers
denim85518843deni__m
denims95214323deni_ms
denizening2142403denizening
denned84215633den_ned
denote74118043denote_
denoted93512763denoted
denotes83817003denotes
dense65923503den_se_
denser74115193den_ser
dented84120513den_ted
dentiled1039743dentiled
dentin73919573den_tin
dentine83320243dentine_
dentines93418403dentines
denude8169353denude_
denuded10167663denuded
denuder9167603denuder
denudes91510043denudes
deride84420033deride_
derided102914253derided
derider93214973derider
derides93420853derides
derive103817043derive_
derived123912763derived
deriver114213913deriver
derives114017813derives
dernier83011943derni_er
design8408933desi_gn
desinent9312963desinent
desire7415303desire_
desired9311983desired
desirer8310783desirer
desires81316133desires
deskmen1435023deskmen
device124512163device_
devices133212583devices
deviled124112183deviled
devise104215753devise_
devised123712563devised
devisee113812713devisee
deviser114212393deviser
devises114116763devises
dewier104013463dewi_er
dexie134716893dexi_e_
dexies145018343dexi_es
dizens164911393d__izens
donzel1636313don_zel
dozen155017473d__ozen
driven105210143d_riven
dunite7315013dunite_
dunites8313593dunites
enliven1034903_enliven
genie66124923geni_e_
genies75324943geni_es
heniquen2042883heniquen
ionize154613873ionize_
ionized172611293ionized
ionizer162310123ionizer
ionizes162813343ionizes
lenient7313843leni_ent
lenite6719983lenite_
lenited8812433lenited
lenites7818443lenites
lensmen937883lensmen
lenten6312883len_ten
menazon1846053menazon
menshen1236813menshen
mizen164815273__mizen
netizens1743863netizens
penile82219603penile_
penises9318193penises
penitent10413503penitent
penmen10311493pen_men
regimen104411573regimen
regiven11478323regiven
renin54830033reni__n
renitent8315333renitent
rerisen73613643rerisen
resize154117723resize_
resized174614903resized
resizes164216843resizes
rewiden1137533rewiden
seize143819503se_ize_
seized164313653se_ized
seizer154114573se_izer
seizes154317533se_izes
seizin153610853se_izin
senile63420213senile_
seniles72618023seniles
teniae64517353teniae_
venin85118663veni__n
venine93718433venine_
venines103516613venines
venire93513693venire_
venires103012453venires
venison1036453venison
wizen175813863__wizen

Search took 9 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.423422437.4
2DLD Change Limit1340271808.03016690.8
3Display Results1801800.283636.0
 (SQL Overall)1786911808.73620454.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.