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

103 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
denizens183557(None) 
denizen1737661denizen_
bedizens2044422bedizens
deniers84515182deni_ers
denies74729642deni_e_s
denizened2042752denizened
dizens164911392d__izens
netizens1743862netizens
adenines9310193adenine_s
agenizes18269743agenize_s
agnizes17328843agnize_s
bedizen1935943bedizen_
benisons1037043benisons
benzene1836343ben_zene
benzenes1946853ben_zenes
benzines1938213benzines
benzins1838693ben_zins
citizens1943983citizens
deadens93410693de_adens
deafens11317253de_afens
decibels1344523decibels
deciders123510753deciders
decides114217653decide_s
deciles104417723decile_s
deepens10307813de_epens
defiers113913993defi_ers
defies104624053defi_e_s
defilers12439473defilers
defiles114016843defile_s
definers124211193definers
defines114118683define_s
definiens1345303definiens
defuzes20398303defuze_s
deicers103612733de_icers
deices94119373de_ice_s
deigns8389983de_i_gns
deionizers2053973deionizers
deionizes1958213deionize_s
delimes10314193delime_s
delivers123310753delivers
demies94825803demi_e_s
demireps1343993demireps
demises103719563demise_s
demonizes21311063demonize_s
dendrons1047393dendrons
denes65639723den__e_s
dengues938183dengue_s
denials84114133deni_als
denied84318633deni_e_d
denier74420693deni_e_r
denimed1159233denime_d
denims95214323deni__ms
denizening2142403denizening
denotes83817003denote_s
dentines93418403dentine_s
dentins83419223den_tins
denuders10165873denuders
denudes91510043denude_s
deriders102411853deriders
derides93420853deride_s
derivers123811363derivers
derives114017813derive_s
designs9328313desi_gns
desinent9312963desinent
desirers939263desirers
desires81316133desire_s
devices133212583device_s
devisees12358283devisees
devisers12339863devisers
devises114116763devise_s
dewiness1238453dewiness
dexies145018343dexi_e_s
dizen155214933d__izen_
donzels1735393don_zels
dozens164612463d__ozens
dunites8313593dunite_s
enlivens1144043_enlivens
genies75324943geni_e_s
heniquens2142503heniquens
ionizers17257713ionizers
ionizes162813343ionize_s
lenient7313843leni_ent
lenites7818443lenite_s
menazons1945733menazons
mizens174610253__mizens
netizen1635883netizen_
penises9318193penise_s
penitent10413503penitent
penitents1147703penitents
regimens11469233regimens
renins64526453reni__ns
renitent8315333renitent
resizes164216843resize_s
rewidens1235533rewidens
seizers164112503se_izers
seizes154317533se_ize_s
seizins164010133se_izins
seniles72618023senile_s
venines103516613venine_s
venins93816703veni__ns
venires103012453venire_s
venisons1136133venisons
wizens186110263__wizens

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.423422437.4
2DLD Change Limit1461621036.84321359.3
3Display Results1031030.0631634.9
 (SQL Overall)1786911037.32924381.4
 
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.