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

129 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
generals910934(None) 
general81010941general_
centrals102712032centrals
federals1247302federals
funerals1146452funerals
genera71211712genera__
generable1238662generable
generalcy1543422generalcy
generalise11178132generalise
generalist11169432generalist
generally1347342generally
generate9312902generate
generates10312722generates
generics11118802generics
generous939772generous
genevas1185252geneva_s
genitals937242genitals
gomerals1147452gomerals
minerals10311392minerals
renewals1137282renewals
severals1137592severals
ventrals112910002ventrals
anneals7449953anne_als
centals94317053cen_tals
central93114473central_
cereals9313173cere_als
cerebrals1354833cerebrals
deferrals1343683deferrals
denials84114133den_ials
dentals83915393den_tals
deverbals1544103deverbals
emerald1046923_emerald
emeralds1144593_emeralds
enemas8812003_enema_s
engrails945383_engrails
engrams1038073_engrams
enrols61213383_en_rols
enteral73516453_enteral_
enthrals11278903_enthrals
entrails8310163_entrails
entraps9109763_entraps
enwraps1284833_enwraps
eternals8238953_eternals
federal1148533federal_
ferals94216643__ferals
funeral1037623funeral_
gangrels1094973gangrels
geegaws1242343ge_egaws
genders93616783gender__s
generalcies1454043generalcies
generalised13185683generalised
generalises12167823generalises
generalists12136943generalists
generality1446193generality
generalize20198453generalize
generalizes21178273generalizes
generalship1752423generalship
generated11310203generated
generator1067593generator
generators1147533generators
generic101310753gener_ic
generical1247003generical_
genes65133093gene___s
geneses82613523gene_ses
genesis82510823gene_sis
genetics11128613genetics
genets75716663gene__ts
genettes938303genettes
geneva1085853geneva__
genial74917613gen_ial_
genipaps1342163genipaps
genital849793genital_
genoas74013623gen_oa_s
genograms1345623genograms
genres75515623gen_r_es
genros74211333gen_r_os
gentians937563gentians
gentries91315273gentries
gerahs1039413g__erahs
gerberas1144963gerbera_s
gesneriads1251543gesneriads
gingals9109313gin_gals
gnarls74210773g_nar_ls
gomeral1038843gomeral_
gomerels1144573gomerels
gomerils1146803gomerils
goners74420173goner__s
goorals838713g_oorals
gorals76917653g__orals
gunmetals1242903gunmetals
humerals1347183humerals
laterals8312753laterals
liberals1039413liberals
literals8312293literals
menials94015693men_ials
menorahs1346543menorahs
mineral9312743mineral_
monerans10310353monerans
nerols6914893__nerols
neutrals846283neutrals
numerals1047343numerals
outgenerals1251413outgenerals
peytrals1355493peytrals
pineals93212853pine_als
referrals1243503referrals
renewal1038713renewal_
rentals74017483ren_tals
repeals94014533repe_als
reseals73917683rese_als
reveals103812743reve_als
reversals1245213reversals
ruderals946073ruderals
sendals81912273sen_dals
senecas939013seneca_s
senegas837253senega_s
senoras72714953senora_s
several1039533several_
telerans859473telerans
tendrils946443tendrils
venerable1438483venerable
venerables1544353venerables
venerably1746423venerably
venerate11312903venerate
venerates12312263venerates
venereal1145093venereal_
veneries112815033veneries
ventral103612173ventral_
vesperals1443933vesperals
veterans1148853veterans

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.420425454.8
2DLD Change Limit1461621297.25020160.3
3Display Results1291290.0502580.0
 (SQL Overall)1786911297.72023146.5
 
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.